Re: Taking database offline

Поиск
Список
Период
Сортировка
От ow
Тема Re: Taking database offline
Дата
Msg-id 20031113155021.46917.qmail@web21407.mail.yahoo.com
обсуждение исходный текст
Ответ на Taking database offline  (ow <oneway_111@yahoo.com>)
Ответы Re: Taking database offline
Список 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 по дате отправления:

Предыдущее
От: ow
Дата:
Сообщение: Re: Taking database offline
Следующее
От: "Telecontrol Networking"
Дата:
Сообщение: Re: can't connect to PostgreSQL Database using pgAdminII