This article will explain how to administer PostgreSQL within Plesk.
Login to your Plesk panel.
Click on the Tools & Settings option under Server Management.
Click on the Updates and Upgrades link under the Panel section.
Click on the Add Components link.
Tick the PostgreSQL server support option, then click on the continue button to install the component.
Once installed login again to your Plesk panel and click on the Subscription link under the Hosting Services section.
Click on the Open in Control Panel option next to the subscription you wish to add a PostgreSQL database to.
Click on the Websites & Domains tab.
Click on the Databases option.
Now create a new database by clicking on the Add New Database button.
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.
Now click on the Add New Database User button to add a user.
Enter a User Name and Password, then click on the OK button.
You can now click on the Webadmin button to login to the database editor.