Talha Awan
Talha Awan

Reputation: 4619

DbVisualizer cannot connect to PostgreSQL database without authentication

I have a local PostgreSQL database that does not require authentication, but I cannot connect it through DbVisualizer when I leave 'Authentication' fields (Database Userid, Database Password) empty.

It shows the following error in Connection Message

An error occurred while establishing the connection:

Long Message:
FATAL: no PostgreSQL user name specified in startup packet

Details:
   Type: org.postgresql.util.PSQLException
   SQL State: 28000

DbVisualizer version is 9.5.6

Upvotes: 2

Views: 3737

Answers (1)

Talha Awan
Talha Awan

Reputation: 4619

As Laurenz Albe pointed out, I did need the username after all. By default it's 'postgres'.

Upvotes: 1

Related Questions