Determining the WAL file needed by a standby

Поиск
Список
Период
Сортировка
От Nicholson, Brad (Toronto, ON, CA)
Тема Determining the WAL file needed by a standby
Дата
Msg-id 2626AEE4839D064CB0472A3814DC403F46CF0E393C@GVW1092EXB.americas.hpqcorp.net
обсуждение исходный текст
Ответы Re: Determining the WAL file needed by a standby  (Jaime Casanova <jaime@2ndquadrant.com>)
Список pgsql-admin

Hi,

 

Once I’ve shut down a streaming replica standby, is there a way from the master I can tell which WAL file is going to be the earliest one needed in order for the replica to catch back up?

 

What I want to do is be able to automatically detect if that WAL file is still around so that the replica can just be started back up and catch up automatically, or if it is gone and  I need to do a resync with the master.


Thanks,

Brad.

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

Предыдущее
От: "Anibal David Acosta"
Дата:
Сообщение: Re: Postgres on NAS/NFS
Следующее
От: Jim Mlodgenski
Дата:
Сообщение: Re: Postgres on NAS/NFS