Disconnecting users for backup etc - Mailing list pgsql-general

From Stephen Davies
Subject Disconnecting users for backup etc
Date
Msg-id 200106010121.KAA00850@mustang.sdc.com.au
Whole thread Raw
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: [HACKERS] extra syntax on INSERT
Next
From: Doug McNaught
Date:
Subject: Re: Disconnecting users for backup etc