password authentication failed (postgresql v8.1.4)
От | Andrea Gozzi |
---|---|
Тема | password authentication failed (postgresql v8.1.4) |
Дата | |
Msg-id | 1150544474.27479.10.camel@osmosis.gnet.eu обсуждение исходный текст |
Ответы |
Re: password authentication failed (postgresql v8.1.4)
Re: password authentication failed (postgresql v8.1.4) Re: password authentication failed (postgresql v8.1.4) |
Список | pgsql-admin |
Hi. I have been upgrading my PG server from version 7.4 (debian sarge binary) to v8.1.4 (source installation). The installation procedure went fine but I can't log into the database with another role/user than 'postgres'. This is my pg_hba.conf, that I was succesfully using with v7.4: # Database administrative login by UNIX sockets local all postgres ident sameuser # All other connections by UNIX sockets local all all ident md5 # All IPv4 connections from localhost host all admin 0.0.0.0 0.0.0.0 md5 host all bdati 0.0.0.0 0.0.0.0 md5 The remote pgAdmin3 obviously doesn't work and neither does the psql command if I try to login with 'admin' or 'bdati'. Users have been created with CREATE ROLE admin WITH PASSWORD 'xxx' SUPERUSER; CREATE ROLE bdati WITH PASSWORD 'xxx' CREATEDB; It's probably one of the dumbest questions but I really can't sort it out. Thanks Andrea -- Andrea Gozzi <andrea.gozzi@linuxrevolution.eu>
Вложения
В списке pgsql-admin по дате отправления: