Re: Consistent PITR backup - Mailing list pgsql-admin

From Thomas Karcher
Subject Re: Consistent PITR backup
Date
Msg-id 1192114238.9842.4.camel@localhost.localdomain
Whole thread Raw
In response to Re: Consistent PITR backup  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-admin
Hi Tom,

> >> I believe the intended way to do this is to look at pg_stop_backup's
> >> return value to determine the last segment you need to archive.
> > Thank you - I saw that, but I didn't have a clue about how to determine
> > the WAL filename in which this segment is to be found ...
> Well, the transformation is pretty trivial, but you can use
> pg_xlogfile_name() to avoid getting your hands dirty.

That's what I was looking for! Thank you!


Best regards from Germany,
Thomas



Attachment

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Consistent PITR backup
Next
From: Simon Riggs
Date:
Subject: Re: Consistent PITR backup