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

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: pg_xlog - files are guaranteed to be sequentialy named?
Дата
Msg-id 46701097.2070501@g2switchworks.com
обсуждение исходный текст
Ответ на Re: pg_xlog - files are guaranteed to be sequentialy named?  (Alvaro Herrera <alvherre@commandprompt.com>)
Список 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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Rodrigo De León
Дата:
Сообщение: Re: Regular expressions in procs
Следующее
От: Greg Smith
Дата:
Сообщение: Re: pg_xlog - files are guaranteed to be sequentialy named?