Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

I've installed pgAdmin3 in my CentOS6. I am using PostgreSQL9.

My problem is that I'm not able to add a server to the pgAdmin3. It gives me an error:

enter image description here

enter image description here

I have not a password for the user "postgres" but I've created a postgresql user just like my regular linux user and I'm able to use "psql":

[andre@andre ~]$ psql
psql (9.0.4)
Type "help" for help.

andre=> \q
[andre@andre ~]$ 

My question is: How can I use pgAdmin3 in CentOS6. there is any trick? I must to enter with the user "postgres"?

Give me a clue.

Best Regards,

share|improve this question

2 Answers 2

up vote 2 down vote accepted

The guru hint is already telling you where to look. You can allow yourself access through the pg_hba.conf file. Since you are connecting locally, you could add a line for local connections to be trusted:

host   all   all   127.0.0.1 255.255.255.255   trust

If you want to use a password, you could add

host   all   all   127.0.0.1 255.255.255.255   <password or md5>

This page should have more in-depth info on the pg_hba.conf file.

EDIT:
The path to pg_hba.conf should be /var/lib/pgsql/data for 32-bits systems, and /var/lib64/pgsql/data for 64-bits systems.

share|improve this answer
    
It worked! Thanks again Sgaduuw! –  André Aug 5 '11 at 12:10

Your clue: read the "Guru Hint" provided. It tells you how to fix the problem.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.