Re: Taking database offline - Mailing list pgsql-admin

From Bruce Momjian
Subject Re: Taking database offline
Date
Msg-id 200311131532.hADFWO217360@candle.pha.pa.us
Whole thread Raw
In response to Re: Taking database offline  (ow <oneway_111@yahoo.com>)
List pgsql-admin
ow wrote:
>
> --- Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> > You can restrict pg_hba.conf to not allow connections just to one
> > database if you want.
> >
>
> True, but that still would not prevent users who are already connected from
> accessing the db, would it?

No, I guess that is the problem.  You can use restart, which will kick
everyone out, or you can use reload, but that doesn't kick people out of
the single database you want.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

pgsql-admin by date:

Previous
From: Markus Espenhain
Date:
Subject: SQL-Statement
Next
From: Markus Espenhain
Date:
Subject: SQL-Statement