X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 0805CD1B23E for ; Wed, 19 May 2004 03:55:45 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 64482-10 for ; Wed, 19 May 2004 03:55:25 -0300 (ADT) Received: from witte.sonytel.be (witte.sonytel.be [80.88.33.193]) by svr1.postgresql.org (Postfix) with ESMTP id 48BC3D1B1AC for ; Wed, 19 May 2004 03:55:23 -0300 (ADT) Received: from gorilla.sonytel.be (localhost [127.0.0.1]) by witte.sonytel.be (8.12.10/8.12.10) with ESMTP id i4J6tNeN014865; Wed, 19 May 2004 08:55:23 +0200 (MEST) Subject: Re: "IDENT authentication failed" but I'm not using ident From: Nico De Ranter To: Tom Lane Cc: postgres-list In-Reply-To: <9460.1084925943@sss.pgh.pa.us> References: <1084883321.13024.115.camel@gorilla.sonytel.be> <9460.1084925943@sss.pgh.pa.us> Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-cFlgXvfjHfXH9LAG1Ble" Organization: Sony NSCE/VPE-Bxl Message-Id: <1084949694.13024.146.camel@gorilla.sonytel.be> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Wed, 19 May 2004 08:54:54 +0200 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/190 X-Sequence-Number: 13506 --=-cFlgXvfjHfXH9LAG1Ble Content-Type: text/plain Content-Transfer-Encoding: quoted-printable On Wed, 2004-05-19 at 02:19, Tom Lane wrote: > Nico De Ranter writes: > > \connect: FATAL: IDENT authentication failed for user "nico" >=20 > > I changed /etc/postgresql/pg_hba.conf so it only contains > > local all all trust=3D20 > > and restarted postgres but I still get the same error message. > > Any idea why the import complains about IDENT authentication when=3D20 > > I'm not even using it and how to get around it? >=20 > If you're getting that message then you *are* using IDENT auth. > My bet is that you changed the wrong config file. /etc/postgresql > is not a very standard name for a Postgres data directory ... Yep, figured that out in the mean time. /etc/postgresql is the standard location on Debian but this seems to have changed with the latest upgrade on Debian/Sarge. >=20 > > BTW: is there a way to create a database and then change ownership > > to somebody else? >=20 > No, but you can do it in one step. >=20 > http://www.postgresql.org/docs/7.4/static/sql-createdatabase.html Damn, should read man-page, should read man-page, should read man-page! Thanks! Nico >=20 > regards, tom lane --=20 --------------------------------------------------------- "It has been said that there are only two businesses that refer to customers as users: illegal drug trade and the computer industry." --------------------------------------------------------- Nico De Ranter Senior System Administrator Sony Service Center (NSCE/VPE-B) The Corporate Village, Da Vincilaan 7-D1 B-1935 Zaventem, Belgium Telephone: +32 (0)2 706 43 11 Fax: +32 (0)2 700 86 22 --=-cFlgXvfjHfXH9LAG1Ble Content-Type: application/pgp-signature; name=signature.asc Content-Description: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.1 (GNU/Linux) iD8DBQBAqwS+GRozxs/SsVoRAqlDAJ9rIqQ9N0cdtJNqKb5WJc0udcG+SgCfXNuy 3FgOxWPwpUZWE3OH8EaSMyk= =iRIl -----END PGP SIGNATURE----- --=-cFlgXvfjHfXH9LAG1Ble--