PostgreSQL with SQL Developer Issue

Question

I added my Third Party JDBC drivers for PostgreSQL, the tab shows up.

However, after I fill in the Username/Pwd and Hostname/Port and then select Choose Database - I get:

Failure -FATAL: database "user1" does not exist

Anyone else having this issue?

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

Same here with SQLDevelopper 4.1.0.17. It seems that you must have a same user name and database name to make it work. — Kloe2378231
– Kloe2378231, Commented Feb 20, 2015 at 15:41

Michele La Ferla · Accepted Answer · 2025-02-13 09:03:16Z

70

If you have a different user and db name, SQLDevelopper 4.1 works with this workarround:

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

Don't forget the "?" character.

Then Select Database becomes available and connection works.

Thanks to Piperopoulos who helped me in this post: Oracle SQL Developer and PostgreSQL

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

select * from pg_catalog.pg_tables;

edited Feb 13 at 9:03

Michele La Ferla

6,88211 gold badges57 silver badges84 bronze badges

answered Feb 23, 2015 at 10:07

Kloe2378231

1,43412 silver badges12 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

User123456 · Accepted Answer · 2014-01-18 02:39:01Z

0

This is a comment- try psql -u user1 in command line to check whether user exist

answered Jan 18, 2014 at 2:39

User123456

2,7483 gold badges31 silver badges46 bronze badges

1 Comment

JB11 Over a year ago

I had the DBA create a dummy DB using the same name as the user. The result was that I was finally able to Choose the DB and connect. However, the connection does not have any info, like the tables, views, etc. I am able to run SQL queries and get results, but that is it. Will keep you posted on our future progress with this issue.

Collectives™ on Stack Overflow

PostgreSQL with SQL Developer Issue

2 Answers 2

Comments

1 Comment

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Linked

Related