Odd behaviour with WAL and pg_stop_backup

Поиск
Список
Период
Сортировка
От Donald Fraser
Тема Odd behaviour with WAL and pg_stop_backup
Дата
Msg-id 000601c6d8c5$161acd50$6464a8c0@DonAcer
обсуждение исходный текст
Ответы Re: Odd behaviour with WAL and pg_stop_backup
Список pgsql-admin
PostgreSQL 8.0.7
OS: Linux Red Hat 4.0


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.

It appears the only way to truly stop it from using the archive command is to
edit the postgresql.conf file, remove the archive command and either issue a
SIGHUP or a server restart.

Can someone confirm that this is the correct behaviour or not?

Thanks in advance,
Donald Fraser



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

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