From: | Shilpa Sudhakar <ssudhakar(at)internode(dot)com(dot)au> |
---|---|
To: | Andrew Sullivan <ajs(at)crankycanuck(dot)ca>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: pg_ctl reload query |
Date: | 2008-02-21 23:11:50 |
Message-ID: | 47BE0536.3080605@internode.com.au |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | Shilpa Sudhakar | 2008-02-21 23:23:25 | WAL archiving |
Previous Message | Lucas Sanabio | 2008-02-21 22:26:19 | Table was deleted but it still been treated as not |