pg_ctl reload seems to not work

From: Frédéric Burlet <fburlet(at)kiala(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: pg_ctl reload seems to not work
Date: 2003-09-16 07:38:23
Message-ID: 1063697903.19896.17.camel@eddie.dev.kiala.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


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>

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Mauricio de Castro 2003-09-16 10:29:39 Re: Report Generator Proposal
Previous Message shilpi jain 2003-09-16 06:39:21 [admin]unsubscribe