Re: Turning slave into a master - PostgreSQL 9.2

On Mon, Oct 31, 2016 at 1:46 PM, Patrick B <patrickbakerbr(at)gmail(dot)com> wrote:

> Hi guys,
>
> I got a test server, let's call it test01.
>
> The test01 has a basebackup from the master.
> I want to turn test01 into a master. It doesn't need to catch up with the
> wal_files, because I don't need it to be up-to-date.
>
> So what I did is:
>
> - Replaced /var/lib/pgsql/9.2/data/ with the basebackup
> - Created recovery.conf:
>
> restore_command = 'cp /var/lib/pgsql/wal_archive/%f %p'
>
> recovery_target_timeline = 'latest'
>
> standby_mode = off
>
> trigger_file = '/tmp/pg_failover_trigger'
>
> - touch /tmp/pg_failover_trigger
> - service postgresql start
>
> And then postgres starts recovering the wal_files. But I don't want that..
> as I don't need a up-to-date
>
> Is the wal_files required anyway?
>
>
​"...has a basebackup from the master" - the answer to your question
depends greatly on the detail behind that sentence.

IIRC, unless you know that the data directory is consistent - because the
database was offline at the time of the backup - at least some WAL will
probably be required to bring the inconsistent backup data directory to a
known good state (i.e., post-checkpoint).

David J.
​
​