Re: Consistent PITR backup

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Karcher <thkarcher(at)gmx(dot)de>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Consistent PITR backup
Date: 2007-10-11 14:47:23
Message-ID: 13579.1192114043@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Thomas Karcher 2007-10-11 14:50:38 Re: Consistent PITR backup
Previous Message Thomas Karcher 2007-10-11 14:37:05 Re: Consistent PITR backup