On 1/23/07, Erick Papadakis <erick.papa@gmail.com> 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