drop postgres database using jdbc

if the user you are using is a superuser or a db owner... then try to use the following...

dropdb +m_project

                                              

1:

yes, program acting as owner. not a security issue

'drop database ' will not work if you or anyone has connected to the database... so use 'dropdb' command.

for more info...

http://www.postgresql.org/docs/7.4/interactive/sql-dropdatabase.html

http://www.postgresql.org/docs/7.4/interactive/app-dropdb.html

then try to use... dbdrop command... which i posted in ID:24994328

excuse me. how would you call postgres commands from inside java?

check the sample code from below link...

http://oracle.anilpassi.com/postgres-sample-jdbc-java-code-2.html

Statement statement = m_conn.createStatement();
statement.execute("dropdb "+m_project);      

I get
org.postgresql.util.PSQLException: ERROR: syntax error at or near "dropdb"

is there some misunderstanding. as I see it, dropdb is a postgres command you enter at the postgres prompt. the code example you provided are jdbc calls inside Java Statements. to me they are not the same. as the test result shows, it does not work that way.

would you like to explain my original question, how would you call a postgres command from inside java?

dropdb is a program that you should run as user postgres via operating system

Process p = Runtime.getRuntime.exec( "dropdb " + m_project );

so, all that, and same result?

That depends on your needs and possibilities. Generally speaking I would not suggest to drop databases from software. But if there's the need, you have the two options as mentioned above.

You might call dropdb as an external application depending on your access rights to the executables (if installed). In this case you should pass the complete path to the dropdb executable and pass also hostname, username and password with appropriate user rights via command line or environment.

You can also use the drop databa command as mentioned in my last comment. There you need to have the right to connect to another database to drop the database. The attached (pseudo) code is used by us sometimes (usually we do not drop databases from the software)

Class.forName("org.postgresql.Driver"); //load the driver
db = DriverManager.getConnection("jdbc:postgresql://hostname/postgres",
                                     username,
                                     password); //connect to the db
Statement stmt = db.createStatement();
stmt.executeUpdate("DROP DATABASE " + dbName);
                                              

1:
2:
3:
4:
5:
6:

I am stuck on
If other users have still a connection open to "x", the drop command will still fail, anyhow.

unless someone suggest a way to disconnect other existing clients, I do not have solution I can use.

you need to shutdown database using os level command

pg_ctl stop -m fast

will terminate all client sessions.

you can then use dropdb command.

I only want to disconnect clients to one db. is that possible?