Skip site navigation (1) Skip section navigation (2)

FATAL: IDENT authentication failed for user "soAndso", quick fix

From: raulpdlr(at)gmail(dot)com
To: pgsql-novice(at)postgresql(dot)org
Subject: FATAL: IDENT authentication failed for user "soAndso", quick fix
Date: 2006-06-16 21:55:00
Message-ID: 1150494900.119167.23630@i40g2000cwc.googlegroups.com (view raw or flat)
Thread:
Lists: pgsql-novice
So what I have is a postgreSQL database and I was trying to connect to
it via a Python module (PyGreSQL) from the same machine.  I created a
table under the user 'postgres' called test_this.

When I started up the machine and logged on, I was the root.  When I
tried to do this:

psql -U postgres -d test_this

I got:

psql: FATAL:  IDENT authentication failed for user "postgres"

so I figured out I had to switch user and be postgres instead of root
with:

su postgres

then, after issuing the same command:

psql -U postgres -d test_this

I had success.

By the way, the same goes if you're trying to access a table via a
Python module.  If the database (or table) is for a certain user, you
must be logged in as that user before you can access it with pg or
pgdb.

Hope that helps someone...


pgsql-novice by date

Next:From: Tom LaneDate: 2006-06-17 00:21:21
Subject: Re: libpq Describe Extension [WAS: Bytea and perl]
Previous:From: Tom LaneDate: 2006-06-16 21:49:00
Subject: Re: Converting stored procedure from mySQL

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group