Re: pg_xlog - files are guaranteed to be sequentialy named? - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: pg_xlog - files are guaranteed to be sequentialy named?
Date
Msg-id 20070613133643.GH4640@alvh.no-ip.org
Whole thread Raw
In response to pg_xlog - files are guaranteed to be sequentialy named?  (Johannes Konert <jkonert@t3go.de>)
Responses Re: pg_xlog - files are guaranteed to be sequentialy named?  (Scott Marlowe <smarlowe@g2switchworks.com>)
Re: pg_xlog - files are guaranteed to be sequentialy named?  (Greg Smith <gsmith@gregsmith.com>)
List pgsql-general
Johannes Konert wrote:
> Hi pgsql-list-members,
> I currently write a small script that deletes outdated xlog-files from
> my backup-location.
> Because I do not want to rely on creation-date, I found it usable to use
> the result of
> ln | sort -g -r
> Thus the newest WAL xlog-file is on top and I can delete all not needed
> files at the bottom of the list.

Warning, this is NOT SAFE to do.  You should NEVER delete "outdated"
xlog files, unless you appreciate RANDOM CORRUPTION of your data.


Not sure how those caps sneaked in there, sorry about that.

Have a nice day,

--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: "Albe Laurenz"
Date:
Subject: Re: setof or array as input parameter to postgresql 8.2 functions
Next
From: Tom Lane
Date:
Subject: Re: psql : Error: Cannot stat /pgdata/8.2/main