Re: Online backup cause boot failure, anyone know why? - Mailing list pgsql-hackers

From Richard
Subject Re: Online backup cause boot failure, anyone know why?
Date
Msg-id 201008052338034811027@vip.sina.com
Whole thread Raw
In response to Online backup cause boot failure, anyone know why?  ("Richard" <husttripper@vip.sina.com>)
Responses Re: Online backup cause boot failure, anyone know why?
List pgsql-hackers
All jods are done by client code, not manually. 
I still did't not understand what you said.
What break what?
Thandks!

------------------                 
Richard
2010-08-05

-------------------------------------------------------------
发件人:Heikki Linnakangas
发送日期:2010-08-05 23:21:54
收件人:Richard
抄送:Tom Lane; pgsql-hackers
主题:Re: [HACKERS] Online backup cause boot failure, anyone know why?

On 05/08/10 17:56, Richard wrote:
> I am sorry, my English is poor.
> I was confused by what you said.
> What do you mean by saying   "that'd break it"!

Replacing CHECKPOINT_WAIT with CHECKPOINT_IMMEDIATE broke it. Don't do that.

If you want to change the behavior of pg_start_backup() to perform the
checkpoint immediately, change "CHECKPOINT_WAIT" to "CHECKPOINT_WAIT |
CHECKPOINT_IMMEDIATE".

The usual work-around though is not to hack the source code, but perform
a manual CHECKPOINT just before calling pg_start_backuo(). That makes
the checkpoint performed by pg_start_backup() finish quickly.

--  Heikki Linnakangas EnterpriseDB   http://www.enterprisedb.com

pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Re: MERGE Specification
Next
From: Robert Haas
Date:
Subject: Re: MERGE Specification