From: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | ow <oneway_111(at)yahoo(dot)com> |
Cc: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>, pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Taking database offline |
Date: | 2003-11-13 15:32:24 |
Message-ID: | 200311131532.hADFWO217360@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
ow wrote:
>
> --- Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Espenhain | 2003-11-13 15:50:01 | SQL-Statement |
Previous Message | Christopher Browne | 2003-11-13 15:23:50 | Re: Question On 7.4RC2 |