Postgres Pro
Downloads
Home   >   mailing lists

Re: how to Stop(shutdown) specific database - Mailing list pgsql-admin

From Scott Mead
Subject Re: how to Stop(shutdown) specific database
Date
Msg-id d3ab2ec80912142021y1d136f70g3a91972fa8f6087a@mail.gmail.com
Whole thread Raw
In response to how to Stop(shutdown) specific database  ("Net Tree Inc." <nettreeinc@gmail.com>)
Responses Re: how to Stop(shutdown) specific database  ("Joshua D. Drake" <jd@commandprompt.com>)
Re: how to Stop(shutdown) specific database  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-admin
Tree view
On Mon, Dec 14, 2009 at 10:32 PM, Net Tree Inc. <nettreeinc@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).

Hope this helps

--Scott

pgsql-admin by date:

Previous
From: "Net Tree Inc."
Date:
Subject: how to Stop(shutdown) specific database
Next
From: "Joshua D. Drake"
Date:
Subject: Re: how to Stop(shutdown) specific database