Re: Odd behaviour with WAL and pg_stop_backup

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Odd behaviour with WAL and pg_stop_backup
Дата
Msg-id 24298.1158329835@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Odd behaviour with WAL and pg_stop_backup  ("Donald Fraser" <postgres@kiwi-fraser.net>)
Список pgsql-admin
Дерево обсуждения 
"Donald Fraser" <postgres@kiwi-fraser.net> writes:
> We have been testing the on-line backup of PostgreSQL and after issuing a
> pg_stop_backup() PostgreSQL is still using the archive command, as set in
> postgresql.conf, for every new WAL block generated.

Um ... why would that surprise you?  That facility is designed for
continuous archiving of WAL.  If you want to make a one-shot dump,
pg_dump is a much better tool.

            regards, tom lane

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Auto Vacuum not starting unless postgres is restarted
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: Postgresql 7.4 migration to (partially) new disks