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: (view raw or whole thread)
Lists: pgsql-admin
Hello List,

i am using the following archive command:
   archive_command = '/usr/bin/rsync -a -F /data/pgsql/%p

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?



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-2015 The PostgreSQL Global Development Group