How do I administer postgreSQL within Plesk?

This article applies to 123 Reg VPS hosting

This article will explain how to administer PostgreSQL within Plesk.

Please note: You must have purchased Power pack and updated your product key before you can use PostgreSQL.

  • Step 1 of 14

    Login to your Plesk panel.

  • Step 2 of 14

    Click on the Tools & Settings option under Server Management.

  • Step 3 of 14

    Click on the Updates and Upgrades link under the Panel section.

  • Step 4 of 14

    Click on the Add Components link.

  • Step 5 of 14

    Tick the PostgreSQL server support option, then click on the continue button to install the component.

  • Step 6 of 14

    Once installed login again to your Plesk panel and click on the Subscription link under the Hosting Services section.

  • Step 7 of 14

    Click on the Open in Control Panel option next to the subscription you wish to add a PostgreSQL database to.

  • Step 8 of 14

    Click on the Websites & Domains tab.

  • Step 9 of 14

    Click on the Databases option.

  • Step 10 of 14

    Now create a new database by clicking on the Add New Database button.

  • Step 11 of 14

    Make sure to select type as PostgreSQL Server and the Database server is set to the default for PostgreSQL. When finished click the OK button.

  • Step 12 of 14

    Now click on the Add New Database User button to add a user.

  • Step 13 of 14

    Enter a User Name and Password, then click on the OK button.

  • Step 14 of 14

    You can now click on the Webadmin button to login to the database editor.