I'm trying to set up phpPgAdmin on my test machine so that I can interface with PostgreSQL without always having to use the
psql CLI. I have PostgreSQL 9.1 installed via the RPM repository, while I installed phpPgAdmin 5.0.4 "manually" (by extracting the archive from the phpPgAdmin website). For the record, my host OS is CentOS 6.2.
I made the following configuration changes already:
pg_hba.conf, I changed all
METHODs to md5.
- I gave the postgres account a password
- I added a new account named webuser with a password (note that I did not do anything else to the account, so I can't exactly say that I know what permissions it has and all)
- Changed the line
$conf['servers']['host'] = '';to
$conf['servers']['host'] = '127.0.0.1';(I've also tried using localhost as the value there).
Whenever I try to log in to phpPgAdmin, I get "Login failed", even if I use successful credentials (ones that work in
psql). I've tried to go through some of the steps noted in Question 3 in the FAQ, but it hasn't worked out well so far there. It likely does not help that this is my first day working with PostgreSQL. I'm farily familiar with MySQL, but I have to use PostgreSQL for the project I'm working on.
Could anyone offer some help for how to set up phpPgAdmin on CentOS 6.2? If I've done something terribly wrong in my configuration so far, it's no big deal to blow something/everything away, as it's not like I've stored any data there yet!
I appreciate any insight you may have!