Saturday, August 27, 2011

Installing PostgreSQL on cPanel Server

August 5, 2009 by  
Filed under cPanel

Leave a Comment

Installing PostgreSQL is not a difficult process, but you should follow the steps below in order to ensure that everything is properly configured.

Note: cPanel requires PostgreSQL 7.3.x or later. Earlier versions will not work.

  1. If necessary, update to cPanel to latest version. You can update cPanel by typing /scripts/upcp from the command line while logged in as root.
  2. SSH to your server as root.
  3. If you have PostgreSQL 7.2.x installed, back up your databases using pg_dumpall or some other method. If you do not have databases you wish to keep, move your existing PostgreSQL data directory somewhere else by, for example, typing the following command:
    • mv /var/lib/pgsql /var/lib/pgsql.old
  4. Type the following command:
    • /scripts/installpostgres
  5. From your web browser, log into WebHost Manager.
  6. Select Postgres Config in the SQL Services section of WHM.
  7. Type a new PostgreSQL password in the text box and click Change Password.
    • Warning: Do not use non-alpha numeric characters, as these cause problems.
  8. If you are installing PostgreSQL for the first time, click the Install Config button.
    • Warning: If you have an existing PostgreSQL configuration, this will overwrite your configuration authentication file ( pg_hba.conf).
  9. If you are upgrading from PostgreSQL 7.2.x or earlier, restore the SQL dump you created in step 3 by using psql or some other method.
  10. PostgreSQL is now accessible from your cPanel interface.

GD Star Rating
a WordPress rating system
Digg This
Reddit This
Stumble Now!
Buzz This
Vote on DZone
Share on Facebook
Bookmark this on Delicious
Kick It on
Shout it
Share on LinkedIn
Bookmark this on Technorati
Post on Twitter
Google Buzz (aka. Google Reader)

Related posts:

  1. What is cPanel?
  2. Install SSL certificate on Windows Server 2000 / 2003

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!
Click here to cancel reply.