| 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 14:54:35 |
| Message-ID: | 200311131454.hADEsZ608721@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:
> >
> > Rather than restart the server (kicking everyone out), does 'reload'
> > help to keep new users out and let the old ones leave on their own?
> >
>
> Not really ... users (old or new) should not work with the db unless it's
> completely loaded. Restarting the server will affect activity in other dbs in
> that cluster which is not desirable :( IMHO, there should be a way to do this
> without restarting the server.
You can restrict pg_hba.conf to not allow connections just to one
database if 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 | Telecontrol Networking | 2003-11-13 15:11:10 | Re: can't connect to PostgreSQL Database using pgAdminII |
| Previous Message | ow | 2003-11-13 14:39:01 | Re: Taking database offline |