Skip site navigation (1) Skip section navigation (2)

Re: how to Stop(shutdown) specific database

From: Scott Mead <scott(dot)lists(at)enterprisedb(dot)com>
To: "Net Tree Inc(dot)" <nettreeinc(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to Stop(shutdown) specific database
Date: 2009-12-15 04:21:09
Message-ID: d3ab2ec80912142021y1d136f70g3a91972fa8f6087a@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-admin
On Mon, Dec 14, 2009 at 10:32 PM, Net Tree Inc. <nettreeinc(at)gmail(dot)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

In response to

Responses

pgsql-admin by date

Next:From: Joshua D. DrakeDate: 2009-12-15 04:27:55
Subject: Re: how to Stop(shutdown) specific database
Previous:From: Net Tree Inc.Date: 2009-12-15 03:32:49
Subject: how to Stop(shutdown) specific database

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group