On Wed, Feb 9, 2011 at 3:37 PM, Nicholson, Brad (Toronto, ON, CA)
> 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
In response to
pgsql-admin by date
|Next:||From: Sam Stearns||Date: 2011-02-10 05:21:16|
|Subject: Perl Libraries and Postgres|
|Previous:||From: Jim Mlodgenski||Date: 2011-02-09 22:49:20|
|Subject: Re: Postgres on NAS/NFS|