Postgres database creation issue ( wrapper )

[parisdns]

I did install postgres and activated it under whm but can't create db from cpanel du to a wrapper issue!?!...

How can I fix this, thanks.

[cpanelkenneth]

Please post the exact error encountered along with your full cPanel version number.

[usercpanel]

Okay I have fixed this. Error was like

--------------------------------------
Error from postgres wrapper: PostgreSQL has not been configured by the administrator. Unable to locate pgpass file.
--------------------------------------

Fixes
1) removed postgresql packages from the server
2) /scripts/installpostgres
3) Login to WHM >> SQL Services >> Postgres Config >> Click on “Install Config”.
4) /scrips/makecpphp