Centos cPanel install postgresql 9

Saytik

• October 22, 2013 04:28

Hello. WHM 11.38.2 (build 7) Centos 5.10 I have installed pgsql repo

• 

  cPanelMichael

  • October 22, 2013 13:54

  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: [QUOTE]# use the correct package for your distro ( view [url=http://yum.postgresql.org/repopackages.php#pg92]PostgreSQL RPM Repository (with Yum) ) > rpm -i 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.

  0
• 

  Saytik

  • October 22, 2013 15:06

  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 [QUOTE] 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 ? ;)

  0
• 

  cPanelMichael

  • October 22, 2013 15:47

  [quote="Saytik, post: 1488251">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.

  0

Please sign in to leave a comment.