Centos cPanel install postgresql 9

[Saytik]

Hello.
WHM 11.38.2 (build 7)
Centos 5.10

I have installed pgsql repo http://yum.pgrpms.org/9.3/redhat/rhel-5-x86_64/pgdg-centos93-9.3-1.noarch.rpm
for postgresql 9.3
I have added exclude=postgresql* to yum to exclude postgresql 8.

Then i have run /scripts/installpostgresql

Setting up Install Process
No package rh-postgresql available.
No package rh-postgresql-devel available.
No package rh-postgresql-libs available.
No package rh-postgresql-server available.

Installed:
postgresql93.x86_64 0:9.3.1-1PGDG.rhel5 postgresql93-devel.x86_64 0:9.3.1-1PGDG.rhel5 postgresql93-libs.x86_64 0:9.3.1-1PGDG.rhel5 postgresql93-server.x86_64 0:9.3.1-1PGDG.rhel5

The follofing symlinks where created for old directory structure:

ln -s /var/lib/pgsql/9.3/backups/ /var/lib/pgsql/
ln -s /var/lib/pgsql/9.3/data/ /var/lib/pgsql/
ln -s /etc/init.d/postgresql-9.3 /etc/init.d/postgresql

Init database:

service postgresql initdb
Initializing database:

 /etc/init.d/postgresql restart
Stopping postgresql service:                               [  OK  ]
Starting postgresql service:                               [  OK  ]

And now i can't find function "Configure Postgres" in WHM ... Please help me

 

[cPanelMichael]

Hello

The following guide was provided on our Edge-Users list in regards to configuring PostgreSQL 9.2. Please note this method is not supported directly by cPanel, and only offered as guidance to a manual workaround. You will need to modify these instructions if you want to use version 9.3 instead of 9.2:

# use the correct package for your distro ( view PostgreSQL RPM Repository (with Yum) )
> rpm -i http://yum.postgresql.org/9.2/redhat/rhel-6-i386/pgdg-centos92-9.2-6.noarch.rpm

# install the server
> yum groupinstall "PostgreSQL Database Server PGDG"

# setup the server
> service postgresql-9.2 initdb
> chkconfig postgresql-9.2 on

# install the symlinks
> cd /usr/pgsql-9.2/bin/; for f in *; do echo $f; [ -e /usr/bin/$f ] && mv /usr/bin/$f /usr/bin/$f.8; ln -s $(pwd)/$f /usr/bin/$f; done
> cd /var/lib/pgsql; ln -s 9.2/backups; ln -s 9.2/data; ln -s 9.2/pgstartup.log

# then in WHM 'configure postres'
- in "Home »SQL Services »Configure Postgres"
o click on install config
o you can also "create users" for previously created cPanel accounts

# you can also install phppgadmin
> /usr/local/cpanel/bin/updatephppgadmin [--force]

Thank you.

 

[Saytik]

Thank you.

 cd /usr/pgsql-9.3/bin/; for f in *; do echo $f; [ -e /usr/bin/$f ] && mv /usr/bin/$f /usr/bin/$f.8; ln -s $(pwd)/$f /usr/bin/$f; done

that helped.



Also, from this link

We will be providing our own packaged version of PostgreSQL. It's tentatively scheduled for version 11.36.

whereis your own packaged version of PostgreSQL ?

 

[cPanelMichael]

whereis your own packaged version of PostgreSQL ?

I don't have any new information to report on this at this time. It still looks to be in the planning phase.

Thank you.