| From: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
|---|---|
| To: | Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> |
| Cc: | Stephen Frost <sfrost(at)snowman(dot)net>, Peter Eisentraut <peter(dot)eisentraut(at)2ndquadrant(dot)com>, Magnus Hagander <magnus(at)hagander(dot)net>, PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_stop_backup(wait_for_archive := true) on standby server |
| Date: | 2017-07-07 07:21:05 |
| Message-ID: | CAB7nPqSd6sy2ck1BXXQ3vbSqJtCv1mMKX_eaYai5S1qr-bk-fw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On Fri, Jul 7, 2017 at 4:06 PM, Masahiko Sawada <sawada(dot)mshk(at)gmail(dot)com> wrote:
> I agree with this idea. I've tried to make it wait for archiving but
> it seems to me that there are other two issues we need to deal with:
> the timeline ID on standby server is always reset after created a
> restart point, and ThisTimeLineID variable of a backend process is not
> set on the standby node when initializing. The former would be easy to
> fix because resetting it is for debugging purposes. However, to deal
> with latter issue, I'm considering the influence on other things.
ThisTimeLineID does not need to be touched. It seems to me that you
should just use the wait timeline as minRecoveryPointTLI, and wait for
segments using this value. The segment and backup history files to
wait for should be defined with minRecoveryPoint.
--
Michael
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2017-07-07 07:25:07 | Re: Postgres process invoking exit resulting in sh-QUIT core |
| Previous Message | K S, Sandhya (Nokia - IN/Bangalore) | 2017-07-07 07:10:08 | Re: Postgres process invoking exit resulting in sh-QUIT core |