{"id":395,"date":"2021-07-23T12:29:04","date_gmt":"2021-07-23T12:29:04","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/install-or-update-postgresql-on-your-cpanel-whm-server\/"},"modified":"2021-07-23T12:29:04","modified_gmt":"2021-07-23T12:29:04","slug":"install-or-update-postgresql-on-your-cpanel-whm-server","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/install-or-update-postgresql-on-your-cpanel-whm-server\/","title":{"rendered":"Install or Update PostgreSQL\u00ae on Your cPanel & WHM Server"},"content":{"rendered":"<\/p>\n
\n
<\/div>\n
\n

Overview<\/h2>\n

This document explains how to install or update PostgreSQL\u00ae on a server. However, we strongly<\/strong> recommend that you allow an experienced PostgreSQL database administrator to perform this process.<\/p>\n

\n
Important:<\/div>\n
\n We only<\/strong> support versions of PostgreSQL that you install with the \/usr\/local\/cpanel\/scripts\/installpostgres<\/code> script. We do not<\/strong> support versions of PostgreSQL that you install via any other method.\n <\/div>\n<\/div>\n
\n
Note:<\/div>\n
\n cPanel & WHM functions with the version of PostgreSQL that ships with your operating system.\n <\/div>\n<\/div>\n

Back up databases<\/h2>\n

Before you install or update PostgreSQL on your server, back up your server\u2019s databases. This action allows you to restore your databases after you install or update PostgreSQL.<\/p>\n

To back up your databases, log in to your server as the root user via SSH and perform the following steps:<\/p>\n

    \n
  1. \n

    Back up the PostgreSQL databases on your server. To do this, run the following command: <\/p>\n

    \n
    pg_dumpall -<\/span>U postgres ><\/span> db.<\/span>out<\/code><\/pre>\n<\/div>\n
    \n
    Note:<\/div>\n
    \n        In this example, db.out<\/code> represents the database backup file.\n    <\/div>\n<\/div>\n<\/li>\n
  2. \n
    To revert to your previous version of PostgreSQL, move your current PostgreSQL data directory. To do this, run the following commands:\n<\/p>\n
    \n
    \n\n\n
    \n
    1\n<\/span>2\n<\/span><\/code><\/pre>\n<\/td>\n
    		\n
      service<\/span> postgresql<\/span> stop<\/span>\n  mv<\/span> \/<\/span>var<\/span>\/<\/span>lib<\/span>\/<\/span>pgsql<\/span> \/<\/span>var<\/span>\/<\/span>lib<\/span>\/<\/span>directory_file_name<\/span> <\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div>\n
    \n
    Note:<\/div>\n
    \n
      \n
    • In this example, \/directory_file_name<\/code> represents the actual directory name.<\/li>\n
    • If you enabled the Monitor option through WHM\u2019s Service Manager<\/em> interface (WHM >> Home >> Service Configuration >> Service Manager<\/em>), deselect the checkbox in the Monitor<\/em> column before you run this command. This action prevents an automatic restart of the PostgreSQL service after you stop it.<\/li>\n<\/ul><\/div>\n<\/div>\n<\/li>\n<\/ol>\n
      Install or upgrade and configure PostgreSQL<\/h2>\n
      To install or upgrade and configure PostgreSQL on your server, perform the following steps:<\/p>\n
        \n
      1. \n
        Run the \/usr\/local\/cpanel\/scripts\/installpostgres<\/code> command to install or upgrade PostgreSQL.<\/p>\n<\/li>\n
      2. \n
        Access WHM\u2019s Configure PostgreSQL<\/em> interface (WHM >> Home >> SQL Services >> Configure PostgreSQL<\/em>).<\/p>\n<\/li>\n
      3. \n
        Click Install Config<\/em> if PostgreSQL does not exist on your server.    <\/p>\n
        \n
        Warning:<\/div>\n
        \n        If a PostgreSQL configuration already<\/strong> exists on your server, this action overwrites<\/strong> your configuration authentication file.\n    <\/div>\n<\/div>\n<\/li>\n
      4. \n
        Click Create Users<\/em> to add current cPanel users to PostgreSQL.<\/p>\n<\/li>\n
      5. \n
        Enter a new password in the Enter New Password<\/em> text box.<\/p>\n<\/li>\n
      6. \n
        Confirm your new password, and click Change Password<\/em>.<\/p>\n
        \n
        Warning:<\/div>\n
        \n        Only<\/strong> use letters and numbers. Non-alphanumeric characters can cause errors to occur.\n    <\/div>\n<\/div>\n<\/li>\n
      7. \n
        Import your databases. To do this, run the following command: <\/p>\n
        \n
        psql -<\/span>U postgres dbname <<\/span> dumpfile.<\/span>sql<\/code><\/pre>\n<\/div>\n<\/li>\n<\/ol>\n
        Restore a previous PostgreSQL version<\/h2>\n
        If the new installation fails, revert to your previous version of PostgreSQL and restore the earlier PostgreSQL data directory. To do this, run the following commands:<\/p>\n
        \n
        \n\n\n
        \n
        1\n<\/span>2\n<\/span>3\n<\/span>4\n<\/span><\/code><\/pre>\n<\/td>\n
        		\n
        service<\/span> postgresql<\/span> stop<\/span>\nmv<\/span> \/<\/span>var<\/span>\/<\/span>lib<\/span>\/<\/span>pgsql<\/span> \/<\/span>var<\/span>\/<\/span>lib<\/span>\/<\/span>directory_file_name<\/span>\nmv<\/span> \/<\/span>var<\/span>\/<\/span>lib<\/span>\/<\/span>pgsql<\/span>.old<\/span> \/<\/span>var<\/span>\/<\/span>lib<\/span>\/<\/span>pgsql<\/span>\nservice<\/span> postgresql<\/span> restart<\/span><\/code><\/pre>\n<\/td>\n<\/tr>\n<\/table>\n<\/div>\n<\/div>\n
        For more information about PostgreSQL, visit the PostgreSQL website.<\/p>\n<\/p><\/div>\n","protected":false},"excerpt":{"rendered":"
        Overview This document explains how to install or update PostgreSQL\u00ae on a server. However, we strongly recommend that you allow an experienced PostgreSQL database administrator to perform this process. Important: We only support versions of PostgreSQL that you install with the \/usr\/local\/cpanel\/scripts\/installpostgres script. We do not support versions of PostgreSQL that you install via any …<\/p>\n","protected":false},"author":1,"featured_media":396,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[1],"tags":[],"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/395"}],"collection":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/comments?post=395"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/395\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/396"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=395"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=395"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=395"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}