Re: Consistent PITR backup

From: Thomas Karcher <thkarcher(at)gmx(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Consistent PITR backup
Date: 2007-10-11 14:50:38
Message-ID: 1192114238.9842.4.camel@localhost.localdomain
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Simon Riggs 2007-10-11 16:02:42 Re: Consistent PITR backup
Previous Message Tom Lane 2007-10-11 14:47:23 Re: Consistent PITR backup