Disconnecting users for backup etc

Поиск
Список
Период
Сортировка
От Stephen Davies
Тема Disconnecting users for backup etc
Дата
Msg-id 200106010121.KAA00850@mustang.sdc.com.au
обсуждение исходный текст
Список pgsql-general
Hello.

What is the recommended method of disconnecting all users while a
database is vacuumed and backed up?

I have tried a stop/start cycle but this doesn't work. The only method
that I have found so far that does work is to kill -9 every postgresql
process but this sounds way too heavy handed.

Cheers and thanks,
Stephen Davies

========================================================================
Stephen Davies Consulting                              scldad@sdc.com.au
Adelaide, South Australia.                             Voice: 08-8177 1595
Computing & Network solutions.                         Fax: 08-8177 0133



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] extra syntax on INSERT
Следующее
От: Doug McNaught
Дата:
Сообщение: Re: Disconnecting users for backup etc