Re: Steps to switch from Master to standby mode :

Поиск
Список
Период
Сортировка
От prakhar jauhari
Тема Re: Steps to switch from Master to standby mode :
Дата
Msg-id CAEd0_=9EFRa4vrveuvdMdGzUu53=x1XeCgFuqWZTJuz72Z=PSw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Steps to switch from Master to standby mode :  (Strahinja Kustudić <strahinjak@nordeus.com>)
Ответы Re: Steps to switch from Master to standby mode :
Список 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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Strahinja Kustudić
Дата:
Сообщение: Re: Steps to switch from Master to standby mode :
Следующее
От: Oscar Calderon
Дата:
Сообщение: Migration of server