On Mon, Dec 14, 2009 at 10:32 PM, Net Tree Inc. <nettree...@gmail.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
