Re: Online backup cause boot failure, anyone know why?

Поиск
Список
Период
Сортировка
От Richard
Тема Re: Online backup cause boot failure, anyone know why?
Дата
Msg-id 201008052338034811027@vip.sina.com
обсуждение исходный текст
Ответ на Online backup cause boot failure, anyone know why?  ("Richard" <husttripper@vip.sina.com>)
Ответы Re: Online backup cause boot failure, anyone know why?  (Nicolas Barbier <nicolas.barbier@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: MERGE Specification
Следующее
От: Robert Haas
Дата:
Сообщение: Re: MERGE Specification