Disconnecting users for backup etc

From: Stephen Davies <scldad(at)sdc(dot)com(dot)au>
To: pgsql-general(at)postgresql(dot)org
Subject: Disconnecting users for backup etc
Date: 2001-06-01 01:21:31
Message-ID: 200106010121.KAA00850@mustang.sdc.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)sdc(dot)com(dot)au
Adelaide, South Australia. Voice: 08-8177 1595
Computing & Network solutions. Fax: 08-8177 0133

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Doug McNaught 2001-06-01 01:38:36 Re: Disconnecting users for backup etc
Previous Message Craig Orsinger 2001-06-01 01:18:53 Re: PostgreSQL security concerns