On 1/23/07, Erick Papadakis <erick.papa@xxxxxxxxx> wrote:
Doesn't work: - psql -U postgres > psql: FATAL: Ident authentication failed for user "postgres" - psql -U postgres -W > psql: FATAL: Ident authentication failed for user "postgres"
that is saying you need to have the password to login to the database. edit pg_hba.conf and change where it says 'ident' on the 127.0.0.1 line to 'trust'. (wihtout quotes).
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.
Maybe this is why MySQL is popular. The thing just works! (Which is all one needs in 99% of simple webbie cases).
no, you just don't know what you are doing. installing mysql and postgresql from source require approximately the same number of steps (actually, pg is IMO easier). Binary installations are going to require different steps depending on the packaging. haven't checked, but if IIRC redhat provided sys v init scripts can do most of the hard work for you: service postgresql start it will bootstrap (initdb) the database cluster, etc. with suitable defaults. merlin
