It looks as if cpanel has configured your pg_hba.conf for ident based authorization, please read the appropriate chapter.
Would appreciate some insights. Where's the step by step guide to make this work? Cpanel/WHM and Plesk are THE most widespread control panels, and I see zilch on postgresql.org that addresses them.
Correct. Also you will find nearly no stuff about using apt-get and rpm, which are some of the most used package systems on Linux on postgresql.org . And nothing about emerge, which is central to Gentoo Linux. And no real documentation to ports, which is prevalent on FreeBsd.
PostgreSQL.org has extensive, detailed documentation of the PostgreSQL database. The ways the database is used or crunched by various installation tools is not covered. That's sad, but the way it is; and you can help to improve it: after you learned the hard way how to make cpanel do what you want, document your steps and send it to the list.
Thanks for trying PostgreSQL,
Harald
-- GHUM Harald Massa persuadere et programmare Harald Armin Massa Reinsburgstraße 202b 70197 Stuttgart 0173/9409607 fx 01212-5-13695179 - Python: the only language with more web frameworks than keywords.