dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users

From: Gourish Singbal <gourish(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: dropdb: database removal failed: ERROR: database "database_name" is being accessed by other users
Date: 2005-02-21 14:21:10
Message-ID: 674d1f8a0502210621233cf44e@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

This Error message was given when i was dropping the database.
There are idle connections to the database as seen from ps -ef | grep postgres

How can i drop the database with out restarting the postgres server.?.

FYI: i am dropping the database to perform restoration of this backup
database using psql from production.

--
Best,
Gourish Singbal

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Gourish Singbal 2005-02-21 15:49:06 Re: ERROR: 40P01:
Previous Message Lorenza Ferrario 2005-02-21 13:47:48 pg_passwd file missing