Re: log entries are not getting into log file

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(at)gallo(dot)ucsf(dot)edu

-----Original Message-----
From: Kevin Grittner [mailto:Kevin(dot)Grittner(at)wicourts(dot)gov]
Sent: Wed 9/19/2007 11:23 AM
To: Tena Sakai; pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] log entries are not getting into log file

>>> On Wed, Sep 19, 2007 at 12:49 PM, in message
<FE44E0D7EAD2ED4BB2165071DB8E328C03062C3E(at)egcrc-ex01(dot)egcrc(dot)org>, "Tena Sakai"
<tsakai(at)gallo(dot)ucsf(dot)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