Install or Update PostgreSQL on Your cPanel Server

1. Handling technical matters related to a server are never easy, especially for those that are technically inept. So, for the convenience of the users of servers and to enhance the technical expertise of all our readers, we have made sure to explain in full detail how to install or update PostgreSQL on a server. Regardless of the efficacy of this content, we strongly recommend that you avail the services of a competent and experienced PostgreSQL database administrator for carrying out this process successfully. Before proceeding further, it is important to mention that the content here is relevant for only those versions of PostgreSQL that are installed with the /usr/local/cpanel/scripts/installpostgres script, and not for the versions of PostgreSQL that have been installed via any other method. Back up Databases Prior to installing or updating PostgreSQL on a server, the server’s databases need to be backed up. This helps to restore the databases post installing or updating PostgreSQL. In order to back up the databases, you are required to log in to your server as the root user. This log in can be ensured via SSH. Next you need to carry out the below-mentioned steps. •Run the following command to back up the PostgreSQL databases on your server Pg_dumpall -U postgres > db.out Here, the database backup file is represntated by db.out •Youneed to move your current PostgreSQL data directory in order to revert to your previous version of PostgreSQL. Run the below-mentioned commands for this purpose.

2. service postgresql stop mv /var/lib/pgsql /var/lib/directory_file_name Here, the actual directory name is represented by /directory_file_name If you enabled the option, “Monitor”, via the Service Manager interface of WHM, then you need to deselect the checkbox that is present in the Monitor column, prior to running this command. This aids in preventing an automatic restart of the service of PostgreSQL, after you stop it. Install/Upgrade and Configure PostgreSQL For installing or upgrading, and configuring PostgreSQL on your server, you need to perform the following steps- •Run the below-mentioned command to install or upgrade PostgreSQL /usr/local/cpanel/scripts/installpostgres •Access the Configure PostgreSQL interface of WHM •Click Install Config, if PostgreSQL is not present on your server. Here, it needs to be mentioned that if a PostgreSQL configuration exists on your server, then this action will overwrite your configuration authentication file. •Click Create Users for adding current cPanel users to PostgreSQL •Now you need to enter a new password in the text box, Enter New Password •Confirm your new password •Click Change Password •Next you need to import your databases. Run the below-mentioned command for this purpose. psql -U postgres dbname < dumpfile.sql Restore a Previous Version of PostgreSQL You can revert to your earlier version of PostgreSQL and subsequently restore the previous PostgreSQL data directory, if the new installation fails. For this purpose you should run the following commands- service postgresql stop mv /var/lib/pgsql /var/lib/directory_file_name mv /var/lib/pgsql.old /var/lib/pgsql service postgresql restart Equipped with this information you can easily install or update PostgreSQL on your cPanel Server. Here, we would like to add that HTS Hosting provides servers and web hosting services that are extremely affordable, efficient, and highly sought-after globally for the outstanding quality of service delivered by us. Our clients frequently describe us with terms such as the, “Best Windows Hosting Company”, the “Best Website Hosting Company”, the “Best Cloud Hosting Company” etc. HTS Hosting’s commitment to

3. constantly deliver top-tier quality is reflected in the popularity of and demand for our services throughout the world. Source: https://www.htshosting.org/knowledge-base/cpanel/138/install-or-update- postgresql-on-your-cpanel-server