pg_reload_conf() does not unset archive_command

Поиск
Список
Период
Сортировка
От Andrus Moor
Тема pg_reload_conf() does not unset archive_command
Дата
Msg-id dp96td$mmo$2@news.hub.org
обсуждение исходный текст
Ответы Re: pg_reload_conf() does not unset archive_command  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Platform:

"PostgreSQL 8.1.0 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special)"

To reproduce:

1. Make sure that postgres.conf file contains in first line:

archive_command = 'copy "%p" "c:/arhiiv/%f"'

2. Edit postgres.conf file by adding # before this line

#archive_command = 'copy "%p" "c:/arhiiv/%f"'

3. Run SELECT pg_reload_conf() in PgAdmin or in other client or use "Reload
configuration" from XP Start menu. Log file contains received SIGHUP,
reloading configuration files as expected.

4. Run SHOW archive_command

Observed:

archive_command value is

copy "%p" "c:/arhiiv/%f"

Expected:

archive_command value is  must be

unset

Before config file reload Postgres must set archive_command  to unset.


Andrus.




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

Предыдущее
От: Madison Kelly
Дата:
Сообщение: Re: Check If PostgreSQL Table Exists
Следующее
От: "Andrus Moor"
Дата:
Сообщение: Last line is not read from postgres.conf