ml ml <mliebherr99@xxxxxxxxxxxxxx> wrote: > i am using the following archive command: > archive_command = '/usr/bin/rsync -a -F /data/pgsql/%p > pgsql@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? The relevant part of the fine manual says: "It is important that the archive command return zero exit status if and only if it succeeded. Upon getting a zero result, PostgreSQL will assume that the file has been successfully archived, and will remove or recycle it. However, a nonzero status tells PostgreSQL that the file was not archived; it will try again periodically until it succeeds." http://www.postgresql.org/docs/8.4/interactive/continuous-archiving.html#BACKUP-ARCHIVING-WAL If you do that, you don't have to worry about any extra copying. If you don't, the files you need might be gone by the time the connectivity recovers. -Kevin -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
