Re: Shutting down postgresql

That's what I was looking for.  Thank you!

-----Original Message-----
From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
Sent: Friday, December 28, 2001 11:43 AM
To: Peter Darley
Cc: Campano, Troy; pgsql-general@postgresql.org
Subject: Re: [GENERAL] Shutting down postgresql


"Peter Darley" <pdarley@Kinesis-CEM.com> writes:
>     Something that caught me up at first is that PostgreSQL won't shut
> down until all it's backends close, which means that if you have an
> application connected that uses pooled or cached connections you will
> probably have to shut it down first.

This depends on how the postmaster is commanded to shut down.  I think what
Troy is looking for is the various stop-mode options to pg_ctl:
http://developer.postgresql.org/docs/postgres/app-pg-ctl.html
or perhaps he wants to know about the underlying signals that can be sent to
the postmaster:
http://developer.postgresql.org/docs/postgres/postmaster-shutdown.html

            regards, tom lane