Installing PostgreSQL to an existing cluster

TIP

Installing the PostgreSQL role requires Enhance 12.22.0 or higher.

To add PostgreSQL to an existing cluster, you need to install the PostgreSQL role on one or more servers.

• Click Servers in the left hand menu
• Choose the server where you want to install PostgreSQL
• Click Add role
• Click Database
• Choose PostgreSQL
• Click Add role

When installing on the control panel server, the required packages are already installed and PostgreSQL is already running. Enhance will just add the relevant configuration to allow for the hosting of customer databases.

If you are adding PostgreSQL to your existing cluster, we recommend installing it on every server where the Application role is installed. The website placement is opportunistic - it will prefer to place the Database role locally to the web server where a website is placed but, if no PostgreSQL role is installed on that server, it will place the role elsewhere in your cluster which might be suboptimal.

Final steps

After installing PostgreSQL, you will need to use the "move server" tool in the left hand menu to assign existing websites to the newly created PostgreSQL server. This will happen automatically for any new websites you add after adding PostgreSQL.

You will also need to edit your packages to add a quote for PostgreSQL databases, the default is 0.