Centos cPanel install postgresql 9

Saytik

Member
Jul 2, 2011
18
0
51
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:
Code:
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:
Code:
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

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
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

Member
Jul 2, 2011
18
0
51
Thank you.
Code:
 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 ? ;)