On Wed, Feb 9, 2011 at 3:37 PM, Nicholson, Brad (Toronto, ON, CA) <bnichol...@hp.com> 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
