Home > Blockchain >  PgAdmin 4 password-less connection to local database via unix socket
PgAdmin 4 password-less connection to local database via unix socket

Time:09-21

I have initialized a pg database as such:

user_name@my_machine$ sudo -u postgres createuser -s user_name
user_name@my_machine$ createdb -T template0 db_name

I can now connect to it via psql via user_name@my_machine$ psql db_name
and everything works well with the CLI tooling.

The relevant auth line of /etc/postgresql/13/main/pg_hba.conf is:
local all all peer

Now I'd like to connect to it via PgAdmin 4, and I can't find a way to tell the interface that I want to connect via unix socket and don't need a password. The sanest way I can think is:
Connection dialogAdvanced Dialog

but the connection is still rejected with a fe_sendauth: no password supplied.

I know I could configure a password for my user and give it, but I'd like to know if I can make PgAdmin behave properly.

CodePudding user response:

Short answer: put /var/run/postgresql in host name/address.

  • Related