From: Jerry Sievers <gsievers19@comcast.net>
To: pgsql-admin@postgresql.org
Subject: pg_rewind: confused about recovery.conf/restore_command
Date: Thu, 04 Jan 2018 23:18:49 -0600
Message-ID: <87fu7khohy.fsf@jsievers.enova.com> (raw)
Pg 9.6.6 on Ubuntu.
I have a master and a streamer/standby. Streamer runs wal_log_hints=on,
archive_mode=always, archive_command='send it to some repo'.
Promote streamer and make some changes to it.
Halt and run pg_rewind as per my understanding of the docs.
Rewind immediately errors out due to missing wal segments on target
system (streamer).
Same target has a recovery.conf at this point w/restore_command that
knows how to fetch wal segment from 'some repo'. ISTM rewind is
supposed to use it to fetch wals.
Success in same attempt if streamer has archive_command='' thus
retaining wals inside data directory.
Running pg_rewind with --progress --debug shows no indication that it's
trying to use restore command and in fact chmod 0 on the recovery.conf
file makes no difference either.
Am I dreaming that this should work? :-)
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
Subject: Re: pg_rewind: confused about recovery.conf/restore_command
In-Reply-To: <87fu7khohy.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