PostgreSQL with SQL Developer Release

Question

I added my third-party JDBC drivers for PostgreSQL, a tab will appear.

However, after I filled in the username / Pwd and the hostname / port, and then select "Select Database": I get:

Failure -FATAL: database "user1" does not exist 

Does anyone else have this problem?

The JDBC driver I'm using is postgresql-8.4-701.jdbc4.jar .

Answer 1

If you have a different username and db, SQLDeveloper 4.1 works with this desktop:

 username: testuser password: mypass Host: 127.0.0.1:1234/testdb? Port: 1234 

Do not forget that? character. Then Select Database becomes available and the connection is working.

Thanks to Piperopoulos for helping me in this post: Oracle SQL Developer and PostgreSQL

Note that schema and tables are not listed in SQLDevelopper. You can use this query to list them manually:

 select * from pg_catalog.pg_tables; 

Answer 2

This is the psql -u user1 compiler on the command line to check if the user exists