Determining the WAL file needed by a standby - Mailing list pgsql-admin

From Nicholson, Brad (Toronto, ON, CA)
Subject Determining the WAL file needed by a standby
Date
Msg-id 2626AEE4839D064CB0472A3814DC403F46CF0E393C@GVW1092EXB.americas.hpqcorp.net
Whole thread Raw
Responses Re: Determining the WAL file needed by a standby  (Jaime Casanova <jaime@2ndquadrant.com>)
List 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 by date:

Previous
From: "Anibal David Acosta"
Date:
Subject: Re: Postgres on NAS/NFS
Next
From: Jim Mlodgenski
Date:
Subject: Re: Postgres on NAS/NFS