Difference between revisions of "PostgreSQL"
(Created page with "place holder") |
|||
| Line 1: | Line 1: | ||
| − | + | __FORCETOC__ | |
| + | |||
| + | ==PostgreSQL== | ||
| + | |||
| + | WHM/cPanel does support PostgreSQL to be installed on your CentOS server. cPanel does recommend that you have an experienced PostgreSQL db administrator for installation, upgrading, and managing this db engine. While the version of CentOS/RedHat is not required for installation of PostgreSQL you can however check the version of CentOS running the following. | ||
| + | |||
| + | cat /etc/centos-release | ||
| + | |||
| + | ==Databases Backup== | ||
| + | |||
| + | It is highly recommend that you backup your databases before <b>upgrading</b> PostgreSQL. Please visit cPanel docs on how to backup your databases before upgrading on PostgreSQL on cPanel: [[http://docs.cpanel.net/twiki/bin/view/AllDocumentation/InstallationGuide/InstallingPostgresql#Backup%databases docs.cpanel.net]] | ||
| + | |||
| + | |||
| + | ==Installing PostgreSQL on your cPanel server== | ||
| + | |||
| + | |||
| + | To begin the installation, SSH into the server and run the following command: | ||
| + | |||
| + | /scripts/installpostgres | ||
| + | |||
| + | ==Configure PostgreSQL Installation in WHM== | ||
| + | |||
| + | Log into WHM/cPanel using your root user/password that came with the welcome email sent when the server was setup. | ||
| + | |||
| + | #Access Configure Postgres in WHM through "SQL Services" | ||
| + | #Click the <i>Install Config</i> button. NOTE: If PostgreSQL is already installed on the server this will overwrite the configuration of the current installation. | ||
| + | #Click <i>Create Users</i> | ||
| + | #Enter a new password for user | ||
| + | |||
| + | |||
| + | [[File:Postgresql_install.png]] | ||
Revision as of 21:50, 15 February 2014
Contents
PostgreSQL
WHM/cPanel does support PostgreSQL to be installed on your CentOS server. cPanel does recommend that you have an experienced PostgreSQL db administrator for installation, upgrading, and managing this db engine. While the version of CentOS/RedHat is not required for installation of PostgreSQL you can however check the version of CentOS running the following.
cat /etc/centos-release
Databases Backup
It is highly recommend that you backup your databases before upgrading PostgreSQL. Please visit cPanel docs on how to backup your databases before upgrading on PostgreSQL on cPanel: [docs.cpanel.net]
Installing PostgreSQL on your cPanel server
To begin the installation, SSH into the server and run the following command:
/scripts/installpostgres
Configure PostgreSQL Installation in WHM
Log into WHM/cPanel using your root user/password that came with the welcome email sent when the server was setup.
- Access Configure Postgres in WHM through "SQL Services"
- Click the Install Config button. NOTE: If PostgreSQL is already installed on the server this will overwrite the configuration of the current installation.
- Click Create Users
- Enter a new password for user
