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.
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 |