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>
Attachment:
signature.asc
Description: This is a digitally signed message part
