Re: Consistent PITR backup - Mailing list pgsql-admin

From Tom Lane
Subject Re: Consistent PITR backup
Date
Msg-id 13579.1192114043@sss.pgh.pa.us
Whole thread Raw
In response to Re: Consistent PITR backup  (Thomas Karcher <thkarcher@gmx.de>)
Responses Re: Consistent PITR backup  (Thomas Karcher <thkarcher@gmx.de>)
List pgsql-admin
Thomas Karcher <thkarcher@gmx.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

pgsql-admin by date:

Previous
From: Thomas Karcher
Date:
Subject: Re: Consistent PITR backup
Next
From: Thomas Karcher
Date:
Subject: Re: Consistent PITR backup