On Wed, 28 Sep 2005, Kris Kiger wrote:
that all relevant wal logs have been archived, save the current one.
My question then is, how do we tell which wal log is X (the one currently
being written to)?
I do something like this in my scripting:
ls -rt /pg_xlog/ | grep -v "backup\|archive" | tail -1
(My pg_xlog is on a different disk set from the PGDATA dir.)
It appears to work fine for me. Don't forget to make a base backup before you
begin the WAL archiving, or you won't be able to restore anything.
--
Jeff Frost, Owner <jeff@xxxxxxxxxxxxxxxxxxxxxx>
Frost Consulting, LLC http://www.frostconsultingllc.com/
Phone: 650-780-7908 FAX: 650-649-1954
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
