How to install postgresql 8.x or higher when cpanel installs a lower version?
• Use cpanel to install postgresql using /scripts/installpostgres • download latest rpms from www.postgresql.org • rpm -e the old version installed by cPanel, except for rh-postgresql-libs Note: Claimed by a poster on linuxjunkies.in as follows: “Do not remove rh-postgresql-libs. It is needed to courier-authlib compatibily” YMMV, so please try with and without rh-postgresql-libs, and feedback on your results. • run /etc/init.d/postgresql initdb Note: If you need UTF8 or other encoding, use -E UTF8 etc. otherwise it will default to ascii • go to WHM, and config postgresql If you missed out the step to set the default encoding Note: Installing your own version of postgresql may break cPanel backup of postgresql databases. If that occurs, you need to do your own backups of postgresql using pg_dumpall If you need to change the default encoding, try the following; it works due to createdb using the encoding of template1 for new databases.
