Andy Shellam wrote: > Archive_command = "mv %p /your/backup/directory/%f"
Don't do this. Postgres itself will remove the file after the archive_command has copied it elsewhere. > Tip: if you're absolutely sure you will never need these transaction logs, > you can use the following command to delete them when they're finished with: > > Archive_command = "rm -f %p" Don't do this either. If you're not using PITR, just set a blank archive_command and Postgres will delete the file as soon as it's not needed anymore. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
