Thread: how to Stop(shutdown) specific database
Quick find out. Does anyone know how to shutdown or to stop a specified database on postgresql that runs few other databases???
oracle has a command like shutdown specified db, don't know if postgresql can do the same
appreciated~
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
On Mon, 2009-12-14 at 23:21 -0500, Scott Mead wrote: > On Mon, Dec 14, 2009 at 10:32 PM, Net Tree Inc. <nettreeinc@gmail.com> > wrote: > > > > 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 > You could also just disable the ability to connect to the database by updating pg_database. > > Hope this helps > > > --Scott -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering If the world pushes look it in the eye and GRR. Then push back harder. - Salamander
On Mon, 2009-12-14 at 23:21 -0500, Scott Mead wrote: > On Mon, Dec 14, 2009 at 10:32 PM, Net Tree Inc. <nettreeinc@gmail.com> > wrote: > > > > 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 > You could also just disable the ability to connect to the database by updating pg_database. > > Hope this helps > > > --Scott -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 503.667.4564 Consulting, Training, Support, Custom Development, Engineering If the world pushes look it in the eye and GRR. Then push back harder. - Salamander