Re: Consistent PITR backup

[Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>]

Thomas Karcher <thkarcher(at)gmx(dot)de> writes:
>> 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.

			regards, tom lane