Re: how to Stop(shutdown) specific database
От
Scott Mead
Тема
Re: how to Stop(shutdown) specific database
Дата
Msg-id
d3ab2ec80912142021y1d136f70g3a91972fa8f6087a@mail.gmail.com
Ответ на
how to Stop(shutdown) specific database (Net Tree Inc.)
Список
Дерево обсуждения
how to Stop(shutdown) specific database "Net Tree Inc." <nettreeinc@gmail.com>
Re: how to Stop(shutdown) specific database Scott Mead <scott.lists@enterprisedb.com>
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>
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 по дате отправления
