| From: | "Richard" <husttripper(at)vip(dot)sina(dot)com> |
|---|---|
| To: | "Heikki Linnakangas" <heikki(dot)linnakangas(at)enterprisedb(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-hackers" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Online backup cause boot failure, anyone know why? |
| Date: | 2010-08-05 15:38:04 |
| Message-ID: | 201008052338034811027@vip.sina.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Robert Haas | 2010-08-05 15:40:27 | Re: MERGE Specification |
| Previous Message | Simon Riggs | 2010-08-05 15:35:08 | Re: MERGE Specification |