Postgresql why can't login with newly created user?

Question

I'm using phppgadmin, connecting with olduser - works fine. But when i create a new user newuser - i cant login with it.

pgbounce.log:

(nodb)/(nouser)@unix:5432 closing because: No such user: newuser (age=0)
(nodb)/(nouser)@unix:5432 Pooler Error: No such user: newuser
(nodb)/(nouser)@unix:5432 login failed: db=template1 user=newuser

But user newuser exists in database - i see it when i login as olduser, also if i make a sql like "select * from pg_shadow;" i see all my users and newuser also as olduser have same parameters.

I tryed to make more users with use of "createuser ... " still cant login with them.

pg_hba.conf:

local   all         postgres                          ident
local   all         all                               trust
host    all         all         127.0.0.1/32          trust
host    all         all         ::1/128               md5

postgresql version 8.4

Please try connecting directly with psql and verify that works. — Craig Ringer
– Craig Ringer, Commented Aug 6, 2014 at 12:50

jjanes · Accepted Answer · 2014-08-07 17:10:12Z

4

Since you are using pgbouncer, you probably need to add the user to user_list.txt.

answered Aug 7, 2014 at 17:10

jjanes

44.9k5 gold badges39 silver badges48 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Postgresql why can't login with newly created user?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related