Search Postgresql Archives

Re: Installing PostgreSQL under Cpanel

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux