Re: Taking database offline - Mailing list pgsql-admin

From ow
Subject Re: Taking database offline
Date
Msg-id 20031113070503.46826.qmail@web21401.mail.yahoo.com
Whole thread Raw
In response to Re: Taking database offline  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Taking database offline  (Oli Sennhauser <oli.sennhauser@bluewin.ch>)
Re: Taking database offline  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
--- Bruce Momjian <pgman@candle.pha.pa.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

pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Taking database offline
Next
From: ow
Date:
Subject: Logging: statements and users