postgresql database

  1. K

    How to install and configure PostgreSQL?

    You can follow below steps to install and configure PostgreSQL. First you have to run below command to install. /usr/local/cpanel/scripts/installpostgres Now login to WHM and go to WHM >> Home >> SQL Services >> Configure PostgreSQL After that you have to click on “Install Config”, if you do...
  2. K

    How to restore previous PostgreSQL version ?

    If you have installed latest version of PostgreSQL and getting issue then you can easily revert tots previous version to make it working. You can run below commands: service postgresql stop mv /var/lib/pgsql /var/lib/directory_file_name mv /var/lib/pgsql.old /var/lib/pgsql service postgresql...
  3. K

    How to backup PostgreSQL database?

    If you want to install latest version of PostgreSQL then first you have to take backup of your database and then try to install or update database. To take backup it is must to have access of root user, you can follow below steps: Login via SSH You can run below command to take backup of your...
  4. K

    How to enable or disable monitor option in PostgreSQL?

    You can follow below steps: Log into WHM. Here you will find “Service Configuration” option, you have to click on it. Now click on “Service Manager” option. You will find “Monitor” column checkbox, you have to deselect it. This option will prevent automatic restart of PostgreSQL service.