| From: | ow <oneway_111(at)yahoo(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
| Cc: | ow <oneway_111(at)yahoo(dot)com>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Taking database offline |
| Date: | 2003-11-13 07:05:03 |
| Message-ID: | 20031113070503.46826.qmail@web21401.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:
>
> 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.
Thanks
__________________________________
Do you Yahoo!?
Protect your identity with Yahoo! Mail AddressGuard
http://antispam.yahoo.com/whatsnewfree
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ow | 2003-11-13 07:10:09 | Logging: statements and users |
| Previous Message | Bruce Momjian | 2003-11-13 05:10:11 | Re: Taking database offline |