Re: Steps to switch from Master to standby mode :

From: prakhar jauhari <prak840(at)gmail(dot)com>
To: Strahinja Kustudić <strahinjak(at)nordeus(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Steps to switch from Master to standby mode :
Date: 2013-05-15 06:12:47
Message-ID: CAEd0_=9EFRa4vrveuvdMdGzUu53=x1XeCgFuqWZTJuz72Z=PSw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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.

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oscar Calderon 2013-05-16 18:04:54 Migration of server
Previous Message Strahinja Kustudić 2013-05-14 21:13:42 Re: Steps to switch from Master to standby mode :