Обсуждение: log entries are not getting into log file
Hi Everybody,
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
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. As
a result, I cannot turn my workstation off.
Can somebody please tell me what's happening? And
how would I fix this?
I am running postgres 8.2.4 on dell, redhad linux
enterprise server.
Thank you in advance.
Regards,
Tena Sakai
tsakai@gallo.ucsf.edu
>>> 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
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
>>> On Wed, Sep 19, 2007 at 1:45 PM, in message <FE44E0D7EAD2ED4BB2165071DB8E328C03062C3F@egcrc-ex01.egcrc.org>, "Tena Sakai" <tsakai@gallo.ucsf.edu> wrote: > > 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. And I find the opposite here: http://www.postgresql.org/docs/8.2/interactive/auth-pg-hba-conf.html -Kevin