Postgres Pro
Downloads
Home   >   mailing lists

Re: Please make it easy to drop a database that is in use - Mailing list pgsql-general

From Raghavendra
Subject Re: Please make it easy to drop a database that is in use
Date
Msg-id CA+h6AhgMSWR2CCCEkum9oQB8+w48ENYfX4Ekw1Vvbkdhx-VBcA@mail.gmail.com
Whole thread Raw
In response to Re: Please make it easy to drop a database that is in use  (Evan Martin <postgresql@realityexists.net>)
List pgsql-general
Tree view

SELECT pg_terminate_backend(procpid)
FROM pg_stat_activity
WHERE datname = 'dropme';

ERROR:  must be superuser to signal other server processes

You can try this approach.


---
Regards,
Raghavendra
EnterpriseDB Corporation

pgsql-general by date:

Previous
From: Evan Martin
Date:
Subject: Re: Please make it easy to drop a database that is in use
Next
From: "Albe Laurenz"
Date:
Subject: Re: Please make it easy to drop a database that is in use