X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 68BC39FA5E9 for ; Sat, 17 Jun 2006 09:30:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 73783-05 for ; Sat, 17 Jun 2006 09:30:35 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from aa002msr.fastwebnet.it (aa002msr.fastwebnet.it [85.18.95.65]) by postgresql.org (Postfix) with ESMTP id 799959FA430 for ; Sat, 17 Jun 2006 09:30:35 -0300 (ADT) Received: from osmosis.gnet.eu (37.244.81.223) by aa002msr.fastwebnet.it (7.2.070.1) id 449067300018BCA7; Sat, 17 Jun 2006 14:30:29 +0200 Subject: Re: password authentication failed (postgresql v8.1.4) From: Andrea Gozzi Reply-To: andrea.gozzi@linuxrevolution.eu To: andy.shellam@mailnetwork.co.uk Cc: pgsql-admin@postgresql.org In-Reply-To: References: Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-HRQ3yptlfprSB44mDIOO" Date: Sat, 17 Jun 2006 14:30:20 +0200 Message-Id: <1150547420.27479.12.camel@osmosis.gnet.eu> Mime-Version: 1.0 X-Mailer: Evolution 2.4.2.1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200606/134 X-Sequence-Number: 22096 --=-HRQ3yptlfprSB44mDIOO Content-Type: text/plain Content-Transfer-Encoding: quoted-printable That was it, now everything's working! Thanks a lot, it seems like I forgot to read that manual page.. Andrea On Sat, 2006-06-17 at 12:56 +0100, Andy Shellam wrote: > http://www.postgresql.org/docs/8.1/static/role-membership.html >=20 > According to the above manual page, the command is like: >=20 > CREATE ROLE joe LOGIN INHERIT; >=20 > (presumably with your WITH PASSWORD and other grants tacked on.) >=20 > > -----Original Message----- > > From: pgsql-admin-owner@postgresql.org [mailto:pgsql-admin- > > owner@postgresql.org] On Behalf Of Andrea Gozzi > > Sent: 17 June 2006 12:41 pm > > To: pgsql-admin@postgresql.org > > Subject: [ADMIN] password authentication failed (postgresql v8.1.4) > >=20 > > 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: > >=20 > >=20 > > # Database administrative login by UNIX sockets > > local all postgres ident sameuser > >=20 > > # All other connections by UNIX sockets > > local all all ident md5 > >=20 > > # 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 > >=20 > >=20 > > 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 > >=20 > > CREATE ROLE admin WITH PASSWORD 'xxx' SUPERUSER; > > CREATE ROLE bdati WITH PASSWORD 'xxx' CREATEDB; > >=20 > > It's probably one of the dumbest questions but I really can't sort it > > out. > >=20 > > Thanks > >=20 > > Andrea > >=20 > >=20 > > -- > > Andrea Gozzi >=20 >=20 > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match --=-HRQ3yptlfprSB44mDIOO Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (GNU/Linux) iD8DBQBEk/XcoIXRn+fZcV0RAqSvAKCvw0DB2Gk/WtIyVLWVwoeJgOHvaQCg0kMV LeJa+zaQ4yiVk4j2/z5KRLw= =5Vbq -----END PGP SIGNATURE----- --=-HRQ3yptlfprSB44mDIOO--