Postgre SQL - Install

[bmcpanel]

I do not use and am not familiar with Postgre. However, I have a customer who wants to use it and I notice in the X theme, there is a place to install Postgre SQL.

However, I do not know how to get it up and going. Instead, I get this error when attempting to install a db via the custoemr control panel.

No such file or directory Is the server running locally and accepting connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

AND, the phpPGMyADmin link gives this error....

>>>> Configuration error: Copy conf/config.inc.php-dist to conf/config.inc.php and edit appropriately.

Is the Postgre SQL feature and phpPGMyAdmin not yet ready? Can anyone help this Postgre newcomer (me)?

Thanks.

cPanel.net Support Ticket Number:

[ehost]

I got the same error message

cPanel.net Support Ticket Number:

[casey]

/scripts/installpostgres

To fix the error with phpPgAdmin, go to /usr/local/cpanel/base/3rdparty/phpPgAdmin and rename conf/config.inc.php-dist to conf/config.inc.php

cPanel.net Support Ticket Number:

[hormigo]

casey, are you running postgres fine?

I have this error

Database Created
Added the database ´test. Password: psql: FATAL 1: Password authentication failed for user "postgres"

cPanel.net Support Ticket Number:

[ehost]

root@ns1 [/etc/rc.d/init.d]# /scripts/installpostgres
installed: postgresql-server-7.2.3-5.73
installed: postgresql-7.2.3-5.73
Initializing database:                                     [FAILED]
Starting postgresql service:                               [FAILED]

cPanel.net Support Ticket Number:

[casey]

Originally posted by hormigo
casey, are you running postgres fine?

I have this error

Database Created
Added the database ´test. Password: psql: FATAL 1: Password authentication failed for user "postgres"

cPanel.net Support Ticket Number:

Nope. I have the same error.

cPanel.net Support Ticket Number:

[casey]

Originally posted by ehost

root@ns1 [/etc/rc.d/init.d]# /scripts/installpostgres
installed: postgresql-server-7.2.3-5.73
installed: postgresql-7.2.3-5.73
Initializing database:                                     [FAILED]
Starting postgresql service:                               [FAILED]

cPanel.net Support Ticket Number:

Try this:

# rpm -qa | grep postgres
Delete everything that appears with the following command:
# rpm -e postgresql-server-7.2.3-5.73 postgresql-7.2.3-5.73 (and anything else, all on one line)
# rm -rf /var/lib/pgsql/data
# /scripts/installpostgres

cPanel.net Support Ticket Number:

[sexy_guy]

These people are nuts!!!!!!!!!!

I ran thought the installpostgresql installation for the 20th time. It installs the following version;

Building local rpm provides list...Done
Adding Dependency postgresql-libs (required by postgresql-server)
Adding Dependency postgresql (required by postgresql-server)
postgresql: not installed.
postgresql-libs: not installed.
postgresql-server: not installed.
Retrieving http://updates.cpanel.net/redhat/upd...-5.73.i386.rpm
Retrieving http://updates.cpanel.net/redhat/upd...-5.73.i386.rpm
Retrieving http://updates.cpanel.net/redhat/upd...-5.73.i386.rpm
Preparing... ########################################### [100%]
1ostgresql-libs ########################################### [ 33%]
2ostgresql ########################################### [ 66%]
3ostgresql-server ########################################### [100%]
Rebuilding local rpm provides list.....postgresql....postgresql-libs....postgresql-server..Done


Then there is a new option that says the following from WHM!

Postgres Config

I take the option and click OK and i see this!!!!

Setting up Postgres Config...You are running an old unsupported postgresql version.
cPanel only supports postgres 7.3.x or better.

So if they only support 7.3.2 why is their updater installing 7.2.3???

Great logic. Use their update program that installs somekind of outdated version!

cPanel.net Support Ticket Number:

[cpanelnick]

http://forums.cpanel.net/showthread.php?threadid=13474

cPanel.net Support Ticket Number: