From: Jerry Sievers <gsievers19@comcast.net>
To: Rui DeSousa <rui.desousa@icloud.com>
Cc: Jerry Sievers <gsievers19@comcast.net>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_rewind: confused about recovery.conf/restore_command
Date: Fri, 05 Jan 2018 13:12:37 -0600
Message-ID: <878tdcqfve.fsf@jsievers.enova.com> (raw)
In-Reply-To: <6EFCAFA0-3555-4F44-A059-3361586984D4@icloud.com>
References: <87fu7khohy.fsf@jsievers.enova.com>
<6EFCAFA0-3555-4F44-A059-3361586984D4@icloud.com>
Rui DeSousa <rui.desousa@icloud.com> writes:
> Hi Jerry,
>
> That has been my experience as well; pg_rewind does not fetch the WAL
> files.
Hmmm, just prior to my email here last night was my 2nd attempt, taking
a few hours of r/d time to eventually conclude that I was
misunderstanding the docs :-)
A few mentions of recovery.conf in the docs themselves plus what I found
searching Google certainly left me with the impression that pg_rewind
itself knows how to try using a restore_command if found in a
recovery.conf file of the target system to fetch WALs.
> You can use following parameter to keep the most recent logs; i.e. a
> couple of hours worth. That will allow pg_rewind to work during that
Yup this is obvious and I tested same with OK results.
> time frame — If it is still missing a WAL file or two you can
> manually copy them over in a pinch.
Yes and in fact I used my restore_command to do so.
>
> wal_keep_segments
>
>
> p.s. I switched to using ZFS snapshots instead.
Oh, my site is quite familiar with FS or SAN/array snapshots and we use
them all the time.
Just felt like pg_rewind looked like something we should try.
I'll wait to see if others can shed more light on this.
Thanks
>
>
--
Jerry Sievers
Postgres DBA/Development Consulting
e: postgres.consulting@comcast.net
p: 312.241.7800
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: gsievers19@comcast.net, rui.desousa@icloud.com
Subject: Re: pg_rewind: confused about recovery.conf/restore_command
In-Reply-To: <878tdcqfve.fsf@jsievers.enova.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox