Hi Kevin,
Thank you for your reply. I will do so at a quiet hour
soon and let you know what happens.
The reason why I used restart (instead of reload) is I
read in the manual that after I edit pg_hba.conf (section
after "# Put your actual configuration here" line), I
needed to restart, not reload. Of course, now that I am
looking for such section of the manual, I cannot find it.
Maybe I just daydreamed it...
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
-----Original Message-----
From: Kevin Grittner [mailto:Kevin.Grittner@wicourts.gov]
Sent: Wed 9/19/2007 11:23 AM
To: Tena Sakai; pgsql-admin@postgresql.org
Subject: Re: [ADMIN] log entries are not getting into log file
>>> On Wed, Sep 19, 2007 at 12:49 PM, in message
<FE44E0D7EAD2ED4BB2165071DB8E328C03062C3E@egcrc-ex01.egcrc.org>, "Tena Sakai"
<tsakai@gallo.ucsf.edu> wrote:
> A few days ago, I edited a line in pg_hba.conf file
> and issued the command
> pg_ctl -D /usr/local/pgsql/data restart
A reload would have done the trick.
> Since then (or very close to that time) lines that
> should go into serverlog file are coming to the
> window from which I issued the above command.
> Can somebody please tell me what's happening? And
> how would I fix this?
Apparently you didn't use the same command line on the restart that you
used on the start. If there's a service script in /etc/init.d/ (perhaps
/etc/init.d/postgresql) you probably should have used that. A restart
through that might get you back to where you want to be.
-Kevin