Verify database migration

Use psql to connect to the Cloud SQL instance:

PGPASSWORD=<DB_PASSWORD> /opt/puppetlabs/server/bin/psql \
  --host=<DB_HOST> \
  --username=postgres

Verify the following:

  • Required roles exist

  • Required databases exist

  • Tables are present

  • Permissions are correct