Re: Taking database offline - Mailing list pgsql-admin

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

pgsql-admin by date:

Previous
From: ow
Date:
Subject: Re: Taking database offline
Next
From: "Telecontrol Networking"
Date:
Subject: Re: can't connect to PostgreSQL Database using pgAdminII