Re: Installing PostgreSQL under Cpanel

On Wed, Jan 24, 2007 at 02:17:53AM +0800, Erick Papadakis wrote:
> Cpanel team takes care of all of this. All it takes is for someone
> like pgsql to wake up, smell the coffee, and get over the ignorance
> about a platform that is the most prevalent in the web hosting world.
> Cpanel is used by millions of users. I'll be surprised if Debian is.

Dunno. I know the Google pagecount for Debian outnumbers that of cPanel
by more than 10-to-1.

> Debian is an OS distro. The equivalent in my case is CentOS. Only a
> small subset of hardcore techies would read a database man that comes
> with an OS distro.

You don't seriously beleive that, do you? Debian occasionally makes
significant changes to software it distributes and someone who doesn't
check the accompanying notes is likely to get confused because what
they have might not match the online documentation.

If you want exactly what's distributed by the Postgresql team, compile
and install it yourself. If someone else compiled it for you, you'd be
wise to check what they setup before looking elsewhere.

> Only option for me is to pour content on these mailing lists (I mean,
> we're in 2007, why is a forum so difficult? It's a lot friendlier than
> a mailing list as I only get content updates for threads I subscribe
> to, and can get there whenever I want...with search and all other
> paraphernalia) or to put it on some blog and hope it shows up on
> google.

There are forums, they just never get anywhere because the critical
mass of users is here. (Personally, I hate forums)

> Which it seldom does. If you think the problem "psql: FATAL: role
> 'root' does not exist" is so common, try it on google with double
> quotes. It returns 5 websites, 3 in English. None of which explains
> anything meaningful.

Your problem is the double quotes, take them out and you get thousands
of pages with your exact problem. Google tip: don't use double quotes
where the error message contains something substituted (like 'root' in
your message).

Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.