{"id":993,"date":"2021-07-23T12:42:59","date_gmt":"2021-07-23T12:42:59","guid":{"rendered":"https:\/\/ssdsunucum.com\/blog\/configure-postgresql\/"},"modified":"2021-07-23T12:42:59","modified_gmt":"2021-07-23T12:42:59","slug":"configure-postgresql","status":"publish","type":"post","link":"https:\/\/ssdsunucum.com\/blog\/configure-postgresql\/","title":{"rendered":"Configure PostgreSQL"},"content":{"rendered":"<\/p>\n
\n
\n
\n

Valid for versions 82 through the latest version<\/em><\/p>\n<\/div>\n

\n

Version:<\/h4>\n

82<\/h4>\n<\/div><\/div>\n
\n

Overview<\/h2>\n

This interface allows you to complete the PostgreSQL\u00ae installation process, create PostgreSQL users, and update the PostgreSQL password.<\/p>\n

\n
Warning:<\/div>\n
\n This interface\u2019s features are for advanced users only<\/strong>. The WHM interface only displays this interface if you have already installed PostgreSQL on your server.\n <\/div>\n<\/div>\n

Postgres Config Install<\/h2>\n

After you install PostgreSQL on your server via the command line, you must<\/strong> use this interface to complete the installation process. To do this, click Install Config.<\/p>\n

\n
Warning:<\/div>\n
\n Only<\/strong> use this feature to complete the PostgreSQL installation process. If a functional installation of PostgreSQL already exists on your server, this feature will<\/strong> overwrite the current pg_hba.conf<\/code> file.\n <\/div>\n<\/div>\n

Create Postgres Users<\/h2>\n

If cPanel accounts already exist on your server, you must create PostgreSQL accounts after the PostgreSQL installation process finishes. To do this, click Create Users<\/em>.<\/p>\n

\n
Note:<\/div>\n
\n When you create new cPanel accounts on a server that already has PostgreSQL installed, the system automatically creates the new cPanel account\u2019s PostgreSQL user. Only<\/strong> use this feature to create PostgreSQL users for existing cPanel accounts, immediately after you install PostgreSQL.\n <\/div>\n<\/div>\n

Postgres Password<\/h2>\n

To update your PostgreSQL password, enter the new password in the text boxes and click Change Password<\/em>.<\/p>\n

Enter and confirm the new password in the appropriate text boxes.<\/p>\n

\n
Note:<\/div>\n
\n
    \n
  • \n

    The system evaluates the password that you enter on a scale of 100 points. 0<\/code> indicates a weak password, while 100<\/code> indicates a very secure password.<\/p>\n<\/li>\n

  • \n

    Some web hosts require a minimum password strength. A green password Strength<\/em> meter indicates that the password is equal to or greater than the required password strength.<\/p>\n<\/li>\n

  • \n

    Click Password Generator<\/em> to generate a strong password. For more information, read our Password & Security documentation.<\/p>\n<\/li>\n<\/ul><\/div>\n<\/div><\/div>\n","protected":false},"excerpt":{"rendered":"

    Valid for versions 82 through the latest version Version: 82 Overview This interface allows you to complete the PostgreSQL\u00ae installation process, create PostgreSQL users, and update the PostgreSQL password. Warning: This interface\u2019s features are for advanced users only. The WHM interface only displays this interface if you have already installed PostgreSQL on your server. Postgres …<\/p>\n","protected":false},"author":1,"featured_media":994,"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\/993"}],"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=993"}],"version-history":[{"count":0,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/posts\/993\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media\/994"}],"wp:attachment":[{"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/media?parent=993"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/categories?post=993"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ssdsunucum.com\/blog\/wp-json\/wp\/v2\/tags?post=993"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}