pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / 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