So i am trying to work with pg admin 3 on a CentOS virtual machine (i "built it vmware workstation"). I am quite new to centOS, and so far so good i believe, i am working hard to learn how to deal with it. Hopefully i will get rid off Windows soon
I've installed pg admin3 with no problems, and everything was going ok, at least i was hopping for that, until i got into a dead end, when i tried to add a new server, i left, as default, the "Maintenance DB : postgres" and the "username: myusername" and running "localhost". I tried to start the proccess, but i got this error (check above)
I already googled it, but still, it hasn't been easy to reach a solution.
For sure this seems like a silly question, but as i said, i'm quite new to this, and i really want to learn it
Thanks in advance,
Ident authentication failed
The server doesn't accept the current user: The server reports
FATAL: Ident authentication failed for user "myusername"
If this message appears, the pg_hba.conf entry found for your client / user / database combination is set to "ident" authentication. Some distributions, e.g. Debian, have this by default. To perform ident based authentication successfully, you need additional setup; see the PostgreSQL help for this. For a beginner, it might be more appropriate to use a different authentication method; MD5 encrypted passwords are a good choice, which can be configured by an entry in pg_hba.conf like this:
host all all 192.168.0.0/24 md5
This example grants MD5 encrypted password access to all databases to all users on the private network 192.168.0.0/24.
You can use the pg_hba.conf editor that is built into pgAdmin III to edit the pg_hba.conf configuration file. After changing pg_hba.conf, you need to trigger a server configuration reload using pg_ctl or by stopping and restarting the server process.
1) Did you restart or reload server after changeing pg_hba.conf file?
yes, i have done it like 100 times (sudo /sbin/service postgresql)
2)But you renamed it to pg_hba.conf right? Where did you put that file I mean did you replace teh original file pg_hba.conf that exists before.
i created a new file like this
sudo cp -r [directory]/pg_hba.conf.sample[(same)directory]pg_hba.conf
3)is that all uncommented lines you got in pg_hba.conf?
yes, i don't have any others...
4) Do you have on your OS other pg_hba.conf files?
using the locate pg_hba.conf it only shows me the one I've created