On Wed, Feb 9, 2011 at 3:37 PM, Nicholson, Brad (Toronto, ON, CA) <bnicholson@xxxxxx> wrote: > 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? > that info is on the standby, you need to execute pg_controldata on the standby and read the Latest checkpoint location, IIRC... then, from that you can now what the segment you need is, but you have to look for it on the master -- Jaime Casanova   Â www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitaciÃn de PostgreSQL -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
