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 9BCC6D1BA93 for ; Tue, 18 May 2004 09:29:27 -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 79931-05 for ; Tue, 18 May 2004 09:29:11 -0300 (ADT) Received: from witte.sonytel.be (witte.sonytel.be [80.88.33.193]) by svr1.postgresql.org (Postfix) with ESMTP id 1660AD1CA37 for ; Tue, 18 May 2004 09:29:06 -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 i4ICT8eN028070 for ; Tue, 18 May 2004 14:29:08 +0200 (MEST) Subject: "IDENT authentication failed" but I'm not using ident From: Nico De Ranter To: postgres-list Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="=-HgF58VQ1Z5rpWzxyhP1u" Organization: Sony NSCE/VPE-Bxl Message-Id: <1084883321.13024.115.camel@gorilla.sonytel.be> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.6 Date: Tue, 18 May 2004 14:28:42 +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/172 X-Sequence-Number: 13488 --=-HgF58VQ1Z5rpWzxyhP1u Content-Type: text/plain Content-Transfer-Encoding: quoted-printable Hi, I'm trying to upgrade postgres to 7.4.2. I've dumped the database on 7.2.1 but when I try to recreate it by doing psql -e template1 (SELECT datdba FROM pg_database WHERE datname =3D 'template0'); DELETE 15 CREATE USER "ids" WITH SYSID 103 PASSWORD 'Yil8t8Wq1yFth' NOCREATEDB NOCREATEUSER; CREATE USER CREATE USER "nico" WITH SYSID 32 CREATEDB CREATEUSER; CREATE USER [...] DELETE FROM pg_group; DELETE 0 \connect: FATAL: IDENT authentication failed for user "nico" I changed /etc/postgresql/pg_hba.conf so it only contains local all all trust=20 and restarted postgres but I still get the same error message. Any idea why the import complains about IDENT authentication when=20 I'm not even using it and how to get around it? BTW: is there a way to create a database and then change ownership to somebody else? (e.g. I want to give a user 1 database to play with but I don't want to allow him to make any other databases) Thanks in advance, Nico --=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 --=-HgF58VQ1Z5rpWzxyhP1u 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) iD8DBQBAqgF5GRozxs/SsVoRAkeeAKCNmAirZKKIVZ3P4S6I2VqgYgBoVgCdFu21 MqMZHFh0/icPEvEJe6ItXqc= =NRJ9 -----END PGP SIGNATURE----- --=-HgF58VQ1Z5rpWzxyhP1u--