Hi. Need some help getting WAL log archiving going, please. PostgreSQL 8.4.2 archive_command = '/usr/local/bin/rsync -e /usr/bin/ssh %p postgres@remoteserver:directory/%f </dev/null' I am able to login to "remoteserver" as user postgres using key-based authentication (trust relationship exists). However WAL archiving is failing with errors like: rsync: link_stat "/opt/PostgreSQL/8.4/data/pg_xlog/00000001000000350000006E" failed: No such file or directory (2) rsync error: some files/attrs were not transferred (see previous errors) (code 23) at main.c(1039) [sender=3.0.6] 2010-01-06 17:15:13 PSTLOG: archive command failed with exit code 23 2010-01-06 17:15:13 PSTDETAIL: The failed archive command was: /usr/local/bin/rsync -e /usr/bin/ssh pg_xlog/00000001000000350000006E postgres@remoteserver:directory/00000001000000350000006E </dev/null 2010-01-06 17:15:13 PSTWARNING: transaction log file "00000001000000350000006E" could not be archived: too many failures /opt/PostgreSQL/8.4/data/pg_xlog/ exists, but there is no "00000001000000350000006E" there. I do have a cron job that cleans files older than 2 days out of the pg_xlog directory; and the key-based login was broken for a few weeks (I just noticed). How do I get Postgres to stop trying to rsync 00000001000000350000006E, and to do rsync all the WAL files that ARE there? I've already tried restarting the database but it remembers about 00000001000000350000006E. Thanks, Aleksey -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
