Cant use PostgreSql

[shionxx]

I cannot use it, it doesnt create the database nor user and if I use phpPGAdmin it prompts me to input the username and password, which I do, but it just tell me the´re incorrect!!!!!!!!!!!!!!

Help Please.
Thx

[chirpy]

Did you setup the admin account password and configuration in WHM? Have you checked for errors in the logs in /var/logs (probably /var/log/messages)? You should probably have a look over on the postgresql site on how to troubleshoot server problems:
http://www.postgresql.org/

[felix220]

This fixed it.


-------------------------------------
Modify /var/lib/pgsql/data/pg_hba.conf from 'md5' to 'trust'

It should contain the following:

local all all trust
host all all 127.0.0.1 255.255.255.255 trust

Restart postgres:
# service postgresql restart
-----------------------------------


http://forums.cpanel.net/f5/postgresql-fixing-39929.html#post189646

[ramborc]

Thanks, fixed the prob for me too.

[Secret Agent]

I tried this, the original database showed up but when I created the new one to test it out it said this:

Database Created
Added the database virtuoso. [a fatal error or timeout occurred while processing this directive]

Any hints?