Installing PostgreSQL on cPanel Server
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.
- 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. - SSH to your server as root.
- 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
- Type the following command:
- /scripts/installpostgres
- From your web browser, log into WebHost Manager.
- Select Postgres Config in the SQL Services section of WHM.
- 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.
- 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
).
- Warning: If you have an existing PostgreSQL configuration, this will overwrite your configuration authentication file (
- 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. - PostgreSQL is now accessible from your cPanel interface.
a WordPress rating system
Related posts: