Help on psql database connect ubuntu 11.04 psql 8.4 :psql: FATAL: Ident authentication failed for user "willow" [closed]

asked 2012-02-15 04:41:02 -0500

zhenli gravatar image

Dear All. I am using ubuntu 11.04 to install psql 8.4 while following the steps on website: http://www.ros.org/wiki/sql_database/Tutorials/Installing%20a%20PostgreSQL%20Server I find two problem. The first one is: I use another user, not root, so I try to modify the file. and psql --username postgres works nice and I can also add the user CREATE ROLE willow LOGIN CREATEDB CREATEROLE PASSWORD 'willow'; I also enable tcp/ip connection # Anybody through TCP/IP with password host all all 0.0.0.0 0.0.0.0 md5


listen_addresses = '*'


Then I restart my computer. Try step 5.1

willow user can connect locally with password

local all willow md5


ps auxw | grep postgresql sudo kill -HUP xxxx


To check that it is working, try logging into psql on localhost as the new user:

psql --username willow --password --dbname postgres


Then I got the following error:

administrator@ubuntu:/etc/postgresql/8.4/main$ psql --username willow --password --dbname postgres Password for user willow:

psql: FATAL: Ident authentication failed for user "willow"

Do I need to change back the setting for "listen_addresses = '*'" as comment local host??


The second question is that when I run sudo apt-get install pgadmin3 and pgadmin3

I can not find the menu with

File -> Add Server...

etc only a plug in item is to add a connect to a server. Who can give a detail explanation on how to setup for local server to run PR2 SimpleGraspingDemo.

Best regards. Zhenli Lu

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by tfoote
close date 2013-09-18 14:10:27

Comments