2

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

Talha Awan
  • 4,573
  • 4
  • 25
  • 40

1 Answers1

1

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

Community
  • 1
  • 1
Talha Awan
  • 4,573
  • 4
  • 25
  • 40
  • 1
    I'm having the same issue, "WHERE" do you enter it. – james emanon May 14 '17 at 21:43
  • Under **Authentication** in `Database Userid` and `Database Password`. The third screen after "New Connection Wizard" in this [tutorial](https://www.youtube.com/watch?v=AEqO9CAYgRU) – Talha Awan May 15 '17 at 12:19