Re: Archiving wal files

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Archiving wal files
Дата
Msg-id 20060725140736.GA18664@surnet.cl
обсуждение исходный текст
Ответ на Archiving wal files  ("Christian Rengstl" <Christian.Rengstl@klinik.uni-regensburg.de>)
Список pgsql-general
Christian Rengstl wrote:
> Hi list,
>
> somehow it seems that in my pg_xlog directory not all wal files are
> deleted after copying them to the archive directory even though the
> archive_status is done for all of them.  Is it safe to delete them
> after they were copied or is it safe to use 'mv' as archive_command?

No, it is not safe nor necessary.  Leave them alone -- Postgres will
automatically reuse them as needed.

--
Alvaro Herrera                                http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.

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

Предыдущее
От: Christian Schoenebeck
Дата:
Сообщение: Re: CASE statement and SETOF values
Следующее
От: Michael Fuhr
Дата:
Сообщение: Re: Lock changes with 8.1 - what's the right lock?