Group: pgsql.admin


Subject: Consistent PITR backup
From: tgl@sss.pgh.pa.us (Tom Lane)
Date: 10/11/2007 10:47:23 AM
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 ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate