Point in Time Recovery (WAL) archive_command

From: ml ml <mliebherr99(at)googlemail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Point in Time Recovery (WAL) archive_command
Date: 2009-07-31 06:34:56
Message-ID: bae225f0907302334k7c861863v7392526d78513938@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hello List,

i am using the following archive command:
archive_command = '/usr/bin/rsync -a -F /data/pgsql/%p
pgsql(at)pg-backup:/restore/walfiles/'

Which works perfectly so far. My problem now is, what happens if the
"pg-backup" server is down for some time and the archove command can
not copy the wal files to the destination anymore? Can i manually sync
the not transfered files? If yes, which ones do i need to copy?

Cheers,
Mario

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Kevin Grittner 2009-07-31 13:45:57 Re: Point in Time Recovery (WAL) archive_command
Previous Message Tom Lane 2009-07-30 21:59:08 Re: Fix corrupt pg_toast table?