Re: pg_ctl reload query

From: Andrew Sullivan <ajs(at)crankycanuck(dot)ca>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: pg_ctl reload query
Date: 2008-02-21 17:02:44
Message-ID: 20080221170244.GL17293@crankycanuck.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Joshua D. Drake 2008-02-21 17:06:09 Re: Stable Release?
Previous Message Alvaro Herrera 2008-02-21 16:59:43 Re: Stable Release?