Re: how to Stop(shutdown) specific database

On Mon, Dec 14, 2009 at 10:32 PM, Net Tree Inc. <nettreeinc(at)gmail(dot)com>wrote:

> Quick find out. Does anyone know how to shutdown or to stop a specified
> database on postgresql that runs few other databases???

Not quite the same no. In Postgres, if you do a:

pg_ctl -D <path/to/data/dir> stop

It will shut all processes down, there is no concept of 'stopping' a
particular database in a postgres cluster.

>
> oracle has a command like shutdown specified db, don't know if postgresql
> can do the same
>
>
If you need to block access, you can use the host based access file
(pg_hba.conf).
http://www.postgresql.org/docs/current/interactive/client-authentication.html

Hope this helps

--Scott