One of our ancient PostgreSQL server's used disk space has increased to 90%. First I've checked the archive command:
archive_command = 'rsync -aq %p /data/wal-archive/%f'
The problem with that command is
rsync is not installed. So I've replaced it with:
archive_command = 'test ! -f /data/pgsql/data/mnt/server/archivedir/%f && cp %p /data/pgsql/data/mnt/server/archivedir/%f'
After the replacement here is the output of
cp: cannot stat `pg_xlog/000000010000000000000001': No such file or directory
I presume beginning of the
pg_xlog files removed by hand. Do you have any idea how to make this archive process work?