Re: 2,2gb of pg_xlog ??

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux