Re: Database shutdown - Mailing list pgsql-general

From Richard Huxton
Subject Re: Database shutdown
Date
Msg-id 3ABC7FB0.604334EB@archonet.com
Whole thread Raw
In response to Database shutdown  ("Christian Marschalek" <cm@chello.at>)
List pgsql-general
Christian Marschalek wrote:
>
> Hi all of you! :o)
>
> I guess I do have to shut down the database before shutting down the
> linux box?
> How would I accomplish this?
> Just by killing the postmaster per pid?

Be careful with that - there's a page on this in the admin's guide. You
should have a pg_ctl script somewhere though so you can just do:

pg_ctl stop

Also has flags for smart shutdown, options starting PG etc - see man pg_ctl.

You might consider putting a postgres start/stop script in your runlevel
startups so Linux will start/stop it for you automatically.

- Richard Huxton

pgsql-general by date:

Previous
From: Richard Huxton
Date:
Subject: Re: from string to table...?
Next
From: Peter Eisentraut
Date:
Subject: Re: INHERITS behavor