Search Postgresql Archives

pg_reload_conf() does not unset archive_command

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux