I'm attempting to delete a database that I've obviously not closed connections from cleanly.
postgres=# DROP DATABASE filters; ERROR: database "filters" is being accessed by other users DETAIL: There are 4 other session(s) using the database. How exactly would one manage this issue from a PostgreSQL administration stand point? I know there are not real users connected to this database but rather zombie connections. Is there a way to force the DROP command or can I manually view / kill connections to this database w/o having to restart the entire PostgreSQL daemon and impact other active databases? -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
