Provisioner installation with Managed Postgres

Learn how to install PerfectScale provisioner with Managed Postgres with this comprehensive guide

To install the PerfectScale Provisioner with Managed Postgres, you first need to set up a Postgres database and then configure its connection details in the config.yaml file for the PerfectScale self-hosted platform.

Prerequisites

1. A running Postgres instance (either self-hosted or managed).

2. Access to the Postgres instance with sufficient privileges to create databases and users.

3. The Postgres instance should be accessible from the PerfectScale on-prem cluster nodes.

We tested it using PostgreSQL version 16.

Provisioning options

You can use one of the following options in order to configure provisioning:

• Manual provisioning - requires manual creation of databases, users, and schemas.

• Automated provisioning - requires passing superuser credentials to PerfectScale on-prem, and it will create databases, users, and schemas on your behalf.

Manual Provisioning

In this case, you don't need to pass superuser (postgres by default) credentials to PerfectScale, instead, you need to manually create databases, users, and schemas.

In the config.yaml file, you need to set the following parameters:

Ensure to update the host, port, and SSL mode to your values.

deploy_postgres_chart: false
deploy_postgres_init_chart: false
postgres_host: <your-postgres-host>
postgres_port: 5432
postgres_ssl_mode: require

To get SQL commands for manual provisioning, use the provisioner CLI tool:

/provisioner pg-init-print

Automated Provisioning

To automate provisioning, you need to pass superuser credentials to PerfectScale. In this case, PerfectScale will create databases, users, and schemas on your behalf.

In the config.yaml file, you need to set the following parameters:

deploy_postgres_chart: false
deploy_postgres_init_chart: true
postgres_host: <your-postgres-host>
postgres_port: 5432
postgres_ssl_mode: require
postgres_admin_user_name: <your-postgres-superuser> # e.g. postgres
postgres_admin_user_pass: <your-postgres-superuser-password>

Postgres superuser credentials are stored in the postgres-creds secret (key postgres-password) in the PerfectScale Onprem namespace.