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]
