Re: Database shutdown

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