I also did that, added the following line to pg_hba.conf: # TYPE DATABASE IP_ADDRESS MASK AUTH_TYPE AUTH_ARGUMEN local localdb ident user
and in pg_ident.conf: # MAP IDENT PGUSERNAME localdb postgres user -----Original Message----- From: Federico Sevilla III [mailto:[EMAIL PROTECTED]] Sent: Monday, April 22, 2002 9:58 AM To: [EMAIL PROTECTED] Subject: Re: [plug] [OT] Postgresql: IDENT authentication failed for user On Sun, 21 Apr 2002 at 22:21, [EMAIL PROTECTED] wrote: > I'm trying to execute the following command as user `postgres' (on RedHat): > > psql -U user -d localdb -e < ./localdb.sql > > and psql gives me the following error: > > psql: FATAL 1: IDENT authentication failed for user "user" > > I've created the user via the wrapper script, `createuser'. What could be > wrong? Check your pg_hba.conf file. I'm guessing PostgreSQL is doing an ident check to see if "user" == "postgres" which is obviously not the case. --> Jijo -- Federico Sevilla III : <http://jijo.free.net.ph/> Network Administrator : The Leather Collection, Inc. GnuPG Key Fingerprint : 0x93B746BE _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED] _ Philippine Linux Users Group. Web site and archives at http://plug.linux.org.ph To leave: send "unsubscribe" in the body to [EMAIL PROTECTED] To subscribe to the Linux Newbies' List: send "subscribe" in the body to [EMAIL PROTECTED]
