pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Nico De Ranter <nico@sonycom.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: postgres-list <pgsql-admin@postgresql.org>
Subject: Re: "IDENT authentication failed" but I'm not using ident
Date: Wed, 19 May 2004 08:54:54 +0200
Message-ID: <1084949694.13024.146.camel@gorilla.sonytel.be> (raw)
In-Reply-To: <9460.1084925943@sss.pgh.pa.us>
References: <1084883321.13024.115.camel@gorilla.sonytel.be>
	<9460.1084925943@sss.pgh.pa.us>

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

view thread (3+ messages)

Message-ID: <1084949694.13024.146.camel@gorilla.sonytel.be>
Permalink:  ../1084949694.13024.146.camel@gorilla.sonytel.be/
Also on:    postgresql.org/message-id/1084949694.13024.146.camel@gorilla.sonytel.be

 · 

reply

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, tgl@sss.pgh.pa.us
  Subject: Re: "IDENT authentication failed" but I'm not using ident
  In-Reply-To: <1084949694.13024.146.camel@gorilla.sonytel.be>
  References: <1084883321.13024.115.camel@gorilla.sonytel.be> <9460.1084925943@sss.pgh.pa.us> <1084949694.13024.146.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