Home > mailing lists

SQL Sessions and the DROP DATABASE command - Mailing list pgsql-jdbc

From	Carl Olivier
Subject	SQL Sessions and the DROP DATABASE command
Date	March 6, 2003 07:22:02
Msg-id	BCEKIKAMLDKFEKBNELFKOELFCGAA.carl@zero-one.co.za Whole thread Raw
In response to	Timestamp precision (Daniel Bruce Lynes <dlynes@shaw.ca>)
Responses	Re: SQL Sessions and the DROP DATABASE command
List	pgsql-jdbc

Greetings.

I need to be able to call the DROP DATABASE database command via JDBC.

Unfortunately I need to kill off any active connections to the specified database before the DROP DATABASE command will work.

Is there anyway from within a JDBC connection to say the template1 database as the superuser on a POSTGRESQL server to:

1. Determine what connections are open and active to a specified database
2. Kill ALL these sessions.

Thank you in advance,

Carl Olivier

From: Daniel Bruce Lynes
Date: 06 March 2003, 01:23:26
Subject: Timestamp precision

From: Chris Malan
Date: 06 March 2003, 10:22:33
Subject: Data Source