| From: | ow <oneway_111(at)yahoo(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| 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:50:21 |
| Message-ID: | 20031113155021.46917.qmail@web21407.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
--- Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> wrote:
> 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.
>
Restarting the db server triggers the whole chain of events: other dbs are
affected, app servers will also need to restarted, and that has to be done
twice (change pg_hba.conf and then reverse). There's got to be a better way.
Thanks
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Naomi Walker | 2003-11-13 15:54:43 | Re: Upgrading to Solaris 9 |
| Previous Message | Markus Espenhain | 2003-11-13 15:50:01 | SQL-Statement |