Re: Please make it easy to drop a database that is in use

From: Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com>
To: Evan Martin <postgresql(at)realityexists(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Please make it easy to drop a database that is in use
Date: 2012-06-21 14:01:35
Message-ID: CA+h6AhgMSWR2CCCEkum9oQB8+w48ENYfX4Ekw1Vvbkdhx-VBcA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

>
>
> 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.

http://archives.postgresql.org/pgsql-general/2012-04/msg00100.php

---
Regards,
Raghavendra
EnterpriseDB Corporation
Blog: http://raghavt.blogspot.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Albe Laurenz 2012-06-21 14:04:18 Re: Please make it easy to drop a database that is in use
Previous Message Evan Martin 2012-06-21 13:51:18 Re: Please make it easy to drop a database that is in use