pg_reload_conf() does not unset archive_command

From: "Andrus Moor" <eetasoft(at)online(dot)ee>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_reload_conf() does not unset archive_command
Date: 2006-01-01 17:56:03
Message-ID: dp96td$mmo$2@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andrus Moor 2006-01-01 17:56:16 Last line is not read from postgres.conf
Previous Message Martijn van Oosterhout 2006-01-01 16:59:13 Re: bit/integer operations in postgres