Re: pg_xlog - files are guaranteed to be sequentialy named?

From: Scott Marlowe <smarlowe(at)g2switchworks(dot)com>
To: Alvaro Herrera <alvherre(at)commandprompt(dot)com>
Cc: Johannes Konert <jkonert(at)t3go(dot)de>, pgsql-general(at)postgresql(dot)org
Subject: Re: pg_xlog - files are guaranteed to be sequentialy named?
Date: 2007-06-13 15:43:19
Message-ID: 46701097.2070501@g2switchworks.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera wrote:
> 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.
>
I think he's talking about deleting pg_xlog files that are being used
for PITR from the backup machine after they've been applied.

But I'm not sure that's really what he meant or not.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Greg Smith 2007-06-13 15:48:33 Re: pg_xlog - files are guaranteed to be sequentialy named?
Previous Message Rodrigo De León 2007-06-13 14:46:04 Re: Regular expressions in procs