Allows you to search a variety of questions and answers
Some of our customers have requested to use the later 8.4.x version of Postgresql instead of the default 8.1 which Cpanel installs and is the latest version they officially support on Centos 5.x. As of this writing Postgresql 9.0 is currently out, but we will not touch on this and it's best to have Centos 6 to run with psql 9.0.
The process of upgrading psql to 8.4.x is actually fairly simple. Just follow these steps:
1. Login as root to your server and run the following commands:
Code:
yum list postgresql84*
This will show you all of the available packages for version 8.4.
2. To install these, run the following:
Code:
yum install -y postgresql84*
3. After the above command is completed, login to WHM and go to SQL Services --> PostgresSQL Config.
4. In the PostgreSQL Config, you will need to click 'Install Config' then 'Yes', 'Create Users' and last but not least create a new password.
5. To be sure the new version is working, restart the Postgresql server within WHM and then run the following command as root:
Code:
psql --version
The command should look something like this:
Code:
psql --version psql (PostgreSQL) 8.4.9 contains support for command-line editing
You are now running the latest PostgreSQL 8.4.9
On another note, here is a few good examples on how to install/upgrade to 9.0:
http://www.postgresonline.com/journa...sql90-yum.html
http://www.postgresonline.com/journa...-with-Yum.html
Great servers, Great Service, Awesome uptime! Our company has been working with AYKSolutions for almost 3 years, hosting several servers for mission-critical projects. The network downtime has been way lower than 30 minutes for OVER 3 years and.. one of our Linux servers scored 450 days of uptime! Needless to say, their Ticket Support always responds in a matter of minutes. At any time of the d ay! I would rate them 10/5 if I could! Kudos to a great company! :)
Dedicated Semi-Managed Server Review I've been using AYKSolutions for about 2 years now and their support and servers have been great. They assisted me with the transition of all my websites and databases from my old server onto their system with no problem. If I ever need them for support or a change they respond fast and always keep me up to date with the status of my support ticket. I highly recommend using this company especially if you're looking for someone to assist with server management. Best of all their cost is great!
I recently switched to AYK Solutions from Softlayer for my dedicated server requirements. I received a much better specification server at significantly reduced cost from what Softlayer could offer me, with many of the previously 'extra' features at Softlayer included in the base price offered by AYK. The support was second to none, and they were extremely helpful in transferring all of my old server accounts over for no additional fee whatsoever.
© 2004 - 2026 AYKsolutions, LLC. All Rights Reserved.
