I think the functions you are looking for are:
pg_last_xlog_receive_location();
pg_last_xlog_replay_location();
-Dan
On Fri, Apr 15, 2011 at 6:09 AM, Ray Stell wrote:
> On Fri, Apr 15, 2011 at 08:52:24AM +0100, Simon Riggs wrote:
> > On Fri, Apr 15, 2011 at 2:25 AM, Ray Stell wrote:
> >
> > >
Alright, thanks guys! I'll start testing it out, see what happens.
---
===
Samuel Nelson
Consistent State
www.consistentstate.com
303-955-0509
===
On Thu, Apr 14, 2011 at 7:23 PM, Greg Sabino Mullane wrote:
>
> -BEGIN PGP SIGNED MESSAGE-
>
On Fri, Apr 15, 2011 at 08:52:24AM +0100, Simon Riggs wrote:
> On Fri, Apr 15, 2011 at 2:25 AM, Ray Stell wrote:
>
> > The cookbook text says, log shipping "is mostly superseded by streaming
> > replication in 9.0, though is still useful as part of a comprehensive
> > backup strategy." ?The impli
On Fri, Apr 15, 2011 at 2:25 AM, Ray Stell wrote:
> The cookbook text says, log shipping "is mostly superseded by streaming
> replication in 9.0, though is still useful as part of a comprehensive
> backup strategy." The implication is that the WAL archive might be
> needed for recovery in some c
