pg_reload_conf() does not unset archive_command - Mailing list 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.