Read the administrator docs again, and look for the line:
This option can only be set at server start.
At the end of a lot of the entries. This is one of them.
I.e. reload won't do, only restart.
On 16 Sep 2003, Frédéric Burlet wrote:
>
> Hi,
>
> When I'm using pg_ctl to reload the config of postgres and nothing
> happens. I mean that the new configuration seems to not be reloaded
> (even if the logs say that a SIGHUP has been sent to postmaster).
>
> The command line I'm using is the following:
> su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl reload -D $PGDATA -s"
>
> ($PGDATA is well defined before the call)
>
> The conf file I modified is postgresql.conf which is located in
> /var/lib/pgsql/data and I changed the value of tcpip_socket from true to
> false (setting this value from false to true has the same effect).
>
> The postgresql version I'm running is 7.3.2
>
> Here below you will find an extract of what i have done.
>
> Thanx for your help.
>
> Fred.
>
>
> <extract>
>
> Before perfoming the following command line, I set tcpip_socket to
> false.
>
> # su -l postgres -s /bin/sh -c "/usr/bin/pg_ctl reload -D $PGDATA -s"
>
> In the log, only this line appears:
> LOG: Received SIGHUP, reloading configuration files
>
> # psql -h localhost kp kp
> Welcome to psql 7.3.2, the PostgreSQL interactive terminal.
> <blablabla...>
>
> Duh!? if I set tcpip_socket to false, normally I should not be able to
> connect to the db anymore by using -h option!
>
> </extract>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>