Isn't there a specific LOGIN privilege now in 8.1? In my PostgreSQL Manager, there's a "can login?" box which if cleared, creates a role, but doesn't allow them to login. Have you tried using the "createuser" wrapper program to do this for you? Andy > -----Original Message----- > From: pgsql-admin-owner@xxxxxxxxxxxxxx [mailto:pgsql-admin- > owner@xxxxxxxxxxxxxx] On Behalf Of Andrea Gozzi > Sent: 17 June 2006 12:41 pm > To: pgsql-admin@xxxxxxxxxxxxxx > Subject: [ADMIN] password authentication failed (postgresql v8.1.4) > > 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@xxxxxxxxxxxxxxxxxx>
