pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
pg_ctl reload query
3+ messages / 2 participants
[nested] [flat]

* pg_ctl reload query
@ 2008-02-21 05:31 Shilpa Sudhakar <ssudhakar@internode.com.au>
  2008-02-21 17:02 ` Re: pg_ctl reload query Andrew Sullivan <ajs@crankycanuck.ca>
  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 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   ` Re: pg_ctl reload query 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 05:31 pg_ctl reload query Shilpa Sudhakar <ssudhakar@internode.com.au>
  2008-02-21 17:02 ` Re: pg_ctl reload query Andrew Sullivan <ajs@crankycanuck.ca>
@ 2008-02-21 23:11   ` Shilpa Sudhakar <ssudhakar@internode.com.au>
  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