pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed"IDENT authentication failed" but I'm not using ident
3+ messages / 2 participants
[nested] [flat]
* "IDENT authentication failed" but I'm not using ident
@ 2004-05-18 12:28 Nico De Ranter <nico@sonycom.com>
0 siblings, 1 reply; 3+ messages in thread
From: Nico De Ranter @ 2004-05-18 12:28 UTC (permalink / raw)
To: pgsql-admin
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: "IDENT authentication failed" but I'm not using ident
@ 2004-05-19 00:19 Tom Lane <tgl@sss.pgh.pa.us>
parent: Nico De Ranter <nico@sonycom.com>
0 siblings, 1 reply; 3+ messages in thread
From: Tom Lane @ 2004-05-19 00:19 UTC (permalink / raw)
To: Nico De Ranter <nico@sonycom.com>; +Cc: pgsql-admin
Nico De Ranter <nico@sonycom.com> writes:
> \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?
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 ...
> BTW: is there a way to create a database and then change ownership
> to somebody else?
No, but you can do it in one step.
http://www.postgresql.org/docs/7.4/static/sql-createdatabase.html
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: "IDENT authentication failed" but I'm not using ident
@ 2004-05-19 06:54 Nico De Ranter <nico@sonycom.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Nico De Ranter @ 2004-05-19 06:54 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-admin
On Wed, 2004-05-19 at 02:19, Tom Lane wrote:
> Nico De Ranter <nico@sonycom.com> writes:
> > \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?
>
> 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.
>
> > BTW: is there a way to create a database and then change ownership
> > to somebody else?
>
> No, but you can do it in one step.
>
> 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
>
> regards, tom lane
--
---------------------------------------------------------
"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
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-05-19 06:54 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-05-18 12:28 "IDENT authentication failed" but I'm not using ident Nico De Ranter <nico@sonycom.com>
2004-05-19 00:19 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-05-19 06:54 ` Nico De Ranter <nico@sonycom.com>
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