pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedpg_ctl reload query
3+ messages / 2 participants
[nested] [flat]
* pg_ctl reload query
@ 2008-02-21 05:31 Shilpa Sudhakar <ssudhakar@internode.com.au>
0 siblings, 1 reply; 3+ messages in thread
From: Shilpa Sudhakar @ 2008-02-21 05:31 UTC (permalink / raw)
To: pgsql-admin
Hi All,
Wanted to know what does pg_ctl do in the background when we run *pg_ctl
-D datadir reload *
After modifying the entries in pg_hba.conf file we ran the reload
command. Generally, it just reloads the files and everything works fine.
But strangely, last time when we ran the reload command and tried to
access *psql dbname, *
It gives a message *"database shutting down" *
As far as i know, this msg appears only when a restart command is given.
Please let me know if my understanding is right and what could have gone
wrong for the db to shutdown.
Thanks and Regards,
Shilpa
*
*
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_ctl reload query
@ 2008-02-21 17:02 Andrew Sullivan <ajs@crankycanuck.ca>
parent: Shilpa Sudhakar <ssudhakar@internode.com.au>
0 siblings, 1 reply; 3+ messages in thread
From: Andrew Sullivan @ 2008-02-21 17:02 UTC (permalink / raw)
To: pgsql-admin
On Thu, Feb 21, 2008 at 04:01:00PM +1030, Shilpa Sudhakar wrote:
> Hi All,
>
> Wanted to know what does pg_ctl do in the background when we run *pg_ctl
> -D datadir reload *
It sends a SIGHUP to the back end.
> command. Generally, it just reloads the files and everything works fine.
> But strangely, last time when we ran the reload command and tried to
> access *psql dbname, *
> It gives a message *"database shutting down" *
Are you sure you didn't issue "restart" instead? It's an easy enough
mistake to make.
A
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: pg_ctl reload query
@ 2008-02-21 23:11 Shilpa Sudhakar <ssudhakar@internode.com.au>
parent: Andrew Sullivan <ajs@crankycanuck.ca>
0 siblings, 0 replies; 3+ messages in thread
From: Shilpa Sudhakar @ 2008-02-21 23:11 UTC (permalink / raw)
To: Andrew Sullivan <ajs@crankycanuck.ca>; pgsql-admin
Thanks for the reply.
I am sure i didn't issue the restart command. i only did the reload.
I'll find out from my other team mates if they issued any restart
command by mistake.
Thanks again.
Regards,
Shilpa
Andrew Sullivan wrote:
> On Thu, Feb 21, 2008 at 04:01:00PM +1030, Shilpa Sudhakar wrote:
>
>> Hi All,
>>
>> Wanted to know what does pg_ctl do in the background when we run *pg_ctl
>> -D datadir reload *
>>
>
> It sends a SIGHUP to the back end.
>
>
>> command. Generally, it just reloads the files and everything works fine.
>> But strangely, last time when we ran the reload command and tried to
>> access *psql dbname, *
>> It gives a message *"database shutting down" *
>>
>
> Are you sure you didn't issue "restart" instead? It's an easy enough
> mistake to make.
>
> A
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/docs/faq
>
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2008-02-21 23:11 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2008-02-21 05:31 pg_ctl reload query Shilpa Sudhakar <ssudhakar@internode.com.au>
2008-02-21 17:02 ` Andrew Sullivan <ajs@crankycanuck.ca>
2008-02-21 23:11 ` Shilpa Sudhakar <ssudhakar@internode.com.au>
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