Re: [ADMIN] 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@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.  

Do you need help?

In addition to our free technical library, Pantek provides professional IT services to companies who utilize Open Source software: Learn more about Pantek's Technical Support offerings Place an order for 24/7/365 Technical Support here Learn more about Pantek, who we are, and what we do Chat with a Live Operator Related postgresql.org Links pgsql-admin pgsql-advocacy pgsql-announce pgsql-bugs pgsql-cygwin pgsql-docs pgsql-general pgsql-interfaces pgsql-jdbc pgsql-jobs pgsql-novice pgsql-odbc pgsql-performance pgsql-php pgsql-ports pgsql-sql Request more information about Pantek

> 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   Received on Wed Sep 19 14:47:28 2007