Re: pg_reload_conf() does not unset archive_command

From: "Qingqing Zhou" <zhouqq(at)cs(dot)toronto(dot)edu>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_reload_conf() does not unset archive_command
Date: 2006-01-01 19:02:54
Message-ID: dp98uo$uft$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


"Andrus Moor" <eetasoft(at)online(dot)ee> wrote in message
news:dp96td$mmo$2(at)news(dot)hub(dot)org(dot)(dot)(dot)
>
> 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Qingqing Zhou 2006-01-01 19:35:02 SET SESSION TRANSACTION command
Previous Message Tom Lane 2006-01-01 18:40:08 Re: pg_reload_conf() does not unset archive_command