Re: pg_reload_conf() does not unset archive_command - Mailing list pgsql-general

From Qingqing Zhou
Subject Re: pg_reload_conf() does not unset archive_command
Date
Msg-id dp98uo$uft$1@news.hub.org
Whole thread Raw
In response to pg_reload_conf() does not unset archive_command  ("Andrus Moor" <eetasoft@online.ee>)
List pgsql-general
"Andrus Moor" <eetasoft@online.ee> wrote in message
news:dp96td$mmo$2@news.hub.org...
>
> 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

This is a known problem - since pg_reload_conf() will ignore the lines with
a # (comment), so the old value is kept.

Regards,
Qingqing



pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: pg_reload_conf() does not unset archive_command
Next
From: John Koller
Date:
Subject: Re: HINT: Perhaps out of disk space?