http://www.postgresql.org/docs/8.1/static/role-membership.html According to the above manual page, the command is like: CREATE ROLE joe LOGIN INHERIT; (presumably with your WITH PASSWORD and other grants tacked on.) > -----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>
