Configure PE to use Google Cloud SQL

This guide describes how to configure Puppet Enterprise (PE) to use a Google Cloud SQL PostgreSQL instance as its backing database.

Before you begin:

Ensure the following:

  • A running PE primary server.

  • Administrative access to:

    • Google Cloud Platform (GCP)

    • The PE primary server

  • Access to the following utilities on the PE primary:

    • psql

    • pg_dump

    • pg_restore

  • Network connectivity from the PE primary to the Cloud SQL instance.

  • A complete backup of the PE primary. PE services must be stopped during the migration process.

Configuring PE to use Google Cloud SQL involves the following high level steps:

  1. Provision a PostgreSQL instance in Google Cloud. See Provision a Cloud SQL PostgreSQL instance.

  2. Configure networking and SSL connectivity. See Configure database connectivity.

  3. Migrate PE database roles and tables. See Migrate PE roles and database tables.

  4. Verify the migration. See Verify database migration.

  5. Update pe.conf to point to the external database. See Update pe.conf.

  6. Apply the configuration. See Apply configuration.

This procedure requires stopping PE services and migrating data. Ensure you have a full backup before proceeding.