Sql developer connection to remote postgresql

Question

I was trying to make connection to remote postgresql on aws and sql developer. I have created a user with name 'demo' and a database with name 'demodatabase' owned by demo.

But i am facing some issue, when making connection, choose database dropdown in sql developer isn't showing any database name.

If i don't choose any database from dropdown and test the connection, it shows an error

"Status : Failure -Test failed: FATAL: database "dbadmin" does not exist".

But if i create a database with the same name as user i.e demo it's getting connected successfully.

I have tested in pgadminIII also, with that it's working absolutely fine. Could anyone please help me out.

Answer 1

In the host name box, put the host name followed by /databasename? (include the question mark) ... so in your case:

host: whatever.amazonaws.com/demodatabase?

You can then ignore the drop down box next to "choose database"