> Gustav Karlsson wrote: >> I am looking for a good method of determining what WAL-segments can be >> deleted from our backup- >> archive. >> >> We are using Postgresql 9.3 and do nightly basebackups along with >> archiving of WAL-segments. >> >> We would like to prevent our backup-archive from growing forever, and >> thus delete basebackups and WAL- >> segments older than say 1 year. >> >> Is there a good way of finding the oldest WAL-segment needed for a given >> basebackup? (If not, what is >> the typical method for deleting old WAL-segments?) > > The backup contains a file "backup_label" which contains a line like > > START WAL LOCATION: 0/83000028 (file 000000010000000000000083) > > That is the oldest file needed for recovery. > > But a simple solution would be to keep WAL archives for one day more than > your oldest > base backup, that way you can never miss a WAL archive that you need. See you: http://www.postgresql.org/docs/current/static/pgarchivecleanup.html Saludos, Gilberto Castillo ETECSA, La Habana, Cuba
--- This message was processed by Kaspersky Mail Gateway 5.6.28/RELEASE running at host imx3.etecsa.cu Visit our web-site: <http://www.kaspersky.com>, <http://www.viruslist.com>
-- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
