Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group