I'm trying to connect to a PostgreSQL 9 database using Oracle SQL Developer 4.1.0.17_29, but I'm not having any success so far.
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
After some researches, it seems that SQLDevelopper is not able to connect a Postgre DB with a different "user name" and "database name". It works only of both are same.
Is it a bug or is it a known limitation ?
The JDBC driver I am using is postgresql-9.4-1200.jdbc41.jar (also tried with postgresql-9.3-1103.jdbc3.jar).
Thanks for your help,
Elise.