PostgreSQL peer authentication not working

Open art-solopov opened this issue 10 years ago • 3 comments

When I'm trying to connect without specifying the host, username and password (which normally lets me log in via the peer authentication), I get the error that I failed the password authentication.

Nov 12 '15 16:11 art-solopov

Did this work for you? https://github.com/brianc/node-postgres/issues/613#issuecomment-127659851

Nov 12 '15 18:11 fabianfiorotto

It kinda did, I connected but every time I try to query a table (e. g. SELECT * FROM "sqerp_development"."public"."offices" LIMIT 1000) I get an error: Cross-database references are not implemented.

I run PostgreSQL 9.4 on an Ubuntu Linux 14.04 machine.

Nov 13 '15 09:11 art-solopov

What happen if you select the database as default in the contextual menu?

Nov 13 '15 11:11 fabianfiorotto