Re: Taking database offline

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Taking database offline
Дата
Msg-id 200311131532.hADFWO217360@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Taking database offline  (ow <oneway_111@yahoo.com>)
Список pgsql-admin
ow wrote:
>
> --- Bruce Momjian <pgman@candle.pha.pa.us> wrote:
> > You can restrict pg_hba.conf to not allow connections just to one
> > database if you want.
> >
>
> True, but that still would not prevent users who are already connected from
> accessing the db, would it?

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.

--
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

В списке pgsql-admin по дате отправления:

Предыдущее
От: Markus Espenhain
Дата:
Сообщение: SQL-Statement
Следующее
От: Markus Espenhain
Дата:
Сообщение: SQL-Statement