From: Nico De Ranter <nico@sonycom.com>
To: postgres-list <pgsql-admin@postgresql.org>
Subject: "IDENT authentication failed" but I'm not using ident
Date: Tue, 18 May 2004 14:28:42 +0200
Message-ID: <1084883321.13024.115.camel@gorilla.sonytel.be> (raw)
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 <db.sql
as user 'postgres', I get
DELETE FROM pg_shadow WHERE usesysid <> (SELECT datdba FROM pg_database
WHERE datname = '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
and restarted postgres but I still get the same error message.
Any idea why the import complains about IDENT authentication when
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
--
---------------------------------------------------------
"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
Attachments:
signature.asc (application/pgp-signature, 188B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: nico@sonycom.com
Subject: Re: "IDENT authentication failed" but I'm not using ident
In-Reply-To: <1084883321.13024.115.camel@gorilla.sonytel.be>
References: <1084883321.13024.115.camel@gorilla.sonytel.be>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox