Postgres Pro
Downloads
Home   >   mailing lists

Re: Steps to switch from Master to standby mode : - Mailing list pgsql-admin

From prakhar jauhari
Subject Re: Steps to switch from Master to standby mode :
Date
Msg-id CAEd0_=9EFRa4vrveuvdMdGzUu53=x1XeCgFuqWZTJuz72Z=PSw@mail.gmail.com
Whole thread Raw
In response to Re: Steps to switch from Master to standby mode :  (Strahinja Kustudić <strahinjak@nordeus.com>)
Responses Re: Steps to switch from Master to standby mode :
List pgsql-admin
Tree view
So to allow a standby to recover WAL files that are missing (using archives or directly copying wall from the new master to the new standby) in order to complete the timeline change, is a wrong approach, I mean is this not safe in term of data not being corrupted? Because i tried this and this seems to change the timeline on the new standby. For this i added following to my recovery file:

restore_command = 'cp <pg_data_dir>/archivedir/%f %p'
recovery_target_timeline = 'latest'

regards,
Prakhar.

pgsql-admin by date:

Previous
From: Strahinja Kustudić
Date:
Subject: Re: Steps to switch from Master to standby mode :
Next
From: Oscar Calderon
Date:
Subject: Migration of server