Re: Installing PostgreSQL under Cpanel

Erick,

- psql -U postgres
> > psql: FATAL: Ident authentication failed for user "postgres"

Nice. This gives us some more information about what kind of client
authorization is configured by cpanel.

You can read everything about client-autorisation on:

http://www.postgresql.org/docs/8.2/interactive/client-authentication.html

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.