pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
log entries are not getting into log file
4+ messages / 2 participants
[nested] [flat]

* log entries are not getting into log file
@ 2007-09-19 17:49  Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 1 reply; 4+ messages in thread

From: Tena Sakai @ 2007-09-19 17:49 UTC (permalink / raw)
  To: pgsql-admin

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

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: log entries are not getting into log file
@ 2007-09-19 18:23  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  parent: Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 1 reply; 4+ messages in thread

From: Kevin Grittner @ 2007-09-19 18:23 UTC (permalink / raw)
  To: Tena Sakai <tsakai@gallo.ucsf.edu>; pgsql-admin

>>> 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
 





^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: log entries are not getting into log file
@ 2007-09-19 18:45  Tena Sakai <tsakai@gallo.ucsf.edu>
  parent: Kevin Grittner <Kevin.Grittner@wicourts.gov>
  0 siblings, 1 reply; 4+ messages in thread

From: Tena Sakai @ 2007-09-19 18:45 UTC (permalink / raw)
  To: Kevin Grittner <Kevin.Grittner@wicourts.gov>; pgsql-admin

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
 

^ permalink  raw  reply  [nested|flat] 4+ messages in thread

* Re: log entries are not getting into log file
@ 2007-09-19 19:19  Kevin Grittner <Kevin.Grittner@wicourts.gov>
  parent: Tena Sakai <tsakai@gallo.ucsf.edu>
  0 siblings, 0 replies; 4+ messages in thread

From: Kevin Grittner @ 2007-09-19 19:19 UTC (permalink / raw)
  To: Tena Sakai <tsakai@gallo.ucsf.edu>; pgsql-admin

>>> 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
 





^ permalink  raw  reply  [nested|flat] 4+ messages in thread


end of thread, other threads:[~2007-09-19 19:19 UTC | newest]

Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-09-19 17:49 log entries are not getting into log file Tena Sakai <tsakai@gallo.ucsf.edu>
2007-09-19 18:23 ` Kevin Grittner <Kevin.Grittner@wicourts.gov>
2007-09-19 18:45   ` Tena Sakai <tsakai@gallo.ucsf.edu>
2007-09-19 19:19     ` Kevin Grittner <Kevin.Grittner@wicourts.gov>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox