--0016e6db2d2252c4e5047abc0b65
Content-Type: text/plain; charset=ISO-8859-1

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~

--0016e6db2d2252c4e5047abc0b65
Content-Type: text/html; charset=ISO-8859-1

Quick find out. Does anyone know how to shutdown or to stop a specified database on postgresql that runs few other databases???<div><br></div><div>oracle has a command like shutdown specified db, don't know if postgresql can do the same</div>
<div><br></div><div>appreciated~</div>

--0016e6db2d2252c4e5047abc0b65--

--0016e6d9a2c7320e84047abcb89a
Content-Type: text/plain; charset=ISO-8859-1

On Mon, Dec 14, 2009 at 10:32 PM, Net Tree Inc. <nettreeinc [at] 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-au thentication.html

Hope this helps

--Scott

--0016e6d9a2c7320e84047abcb89a
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

<div class=3D"gmail_quote">On Mon, Dec 14, 2009 at 10:32 PM, Net Tree Inc. =
<span dir=3D"ltr"><<a href=3D"mailto:nettreeinc [at] gmail.com">nettreeinc [at] gm=
ail.com</a>></span> wrote:<br><blockquote class=3D"gmail_quote" style=3D=
"margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex;">
Quick find out. Does anyone know how to shutdown or to stop a specified dat=
abase on postgresql that runs few other databases???</blockquote><div><br><=
/div><div>=A0=A0Not quite the same no. =A0In Postgres, if you do a:</div><d=
iv>
<br></div><div><br></div><div>=A0pg_ctl -D <path/to/data/dir> stop</d=
iv><div><br></div><div>=A0=A0It will shut all processes down, there is no c=
oncept of 'stopping' a particular database in a postgres cluster.</=
div>
<div>=A0</div><blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;=
border-left:1px #ccc solid;padding-left:1ex;"><div><br></div><div>oracle ha=
s a command like shutdown specified db, don't know if postgresql can do=
the same</div>

<div><br></div></blockquote><div><br></div><div>=A0=A0 If you need to block=
access, you can use the host based access file (pg_hba.conf).</div><div><a=
href=3D"http://www.postgresql.org/docs/current/interactive/c lient-authenti=
cation.html">http://www.postgresql.org/docs/current/interact ive/client-auth=
entication.html</a></div>
<div><br></div><div>Hope this helps</div><div><br></div><div>--Scott</div><=
/div>

--0016e6d9a2c7320e84047abcb89a--

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 [at] 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-au thentication.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


--
Sent via pgsql-admin mailing list (pgsql-admin [at] postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin