CODEWITHSUNDEEP
postgresqlpgadmin-4
Dean Schulze
Dean Schulze

Reputation: 10303

pgadmin4 can't connect to postgresql 14

I've installed postgresql 14 and pgadmin4 on Ubuntu 20.04. I set a password with sudo passwd postgres and restarted postgresql I've modified the METHOD settings in /etc/postgresql/14/main/pg_hba.conf to be trust. But pgadmin4 refuses to connect with this message:enter image description here

This used to be all it took to get pgadmin4 to connect.

Is there something new in Postgresql 14 that has to be done?

Upvotes: 0

Views: 3669

Answers (1)

Dan
Dan

Reputation: 11

Thank you, I was going crazy trying to resolve this issue for the last 3 days until I hit this post.

I recently installed PostgreSQL 14 on Ubuntu 20.04 and was trying pgAdmin 4 v. 6.7 and was not able to even create a server without having an INTERNAL SERVER ERROR message. The issue was that when installing PostgreSQL I simply used the same Linux root user password and did not specify a password for the postgres user as you mentioned in the line:

psql -c "ALTER USER postgres WITH PASSWORD 'secure_password_here';"

Thank you

Upvotes: 1

Related Questions