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:
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
.