Symptoms
-
The Microsoft or Postgre SQL database server is not available in the Database server type drop-down menu in Tools & Settings > Database Servers > Add Database Server.
-
The Microsoft or Postgre SQL Server support has the Off value in Tools & Settings > License Management.
- The Microsoft or Postgre SQL Server is shown as “not running” without the option to run it in Tools & Settings > Services Management
- The Microsoft or Postgre SQL Server is shows as Installed in Tools & Settings > Updates > Add/Remove Component
- Cannot install PostgreSQL via CLI:
# plesk bin database-server –create-server localhost:5432 -type postgresql -admin admin -passwd ‘password’
To use Postgresql server, you need the support for it in your license key. Please consult your Plesk sales representative.
Cause
The support of the database server is not included in the Plesk license.
Resolution
Both Microsoft SQL and PostgreSQL options are available as part of the following feature packs:
Thus, one of these feature packs should be purchased to support options for the license.
Plesk Web Pro and Plesk Web Host editions include the Microsoft SQL and Postgre SQL support by default and allows using these database servers.
Web Admin Edition does not provide Developer Pack by default, so Microsoft SQL and Postgre SQL are not available for this type of license.
After the feature is available in the license, use this documentation article to add support of the required database server.