PostgreSQL Configuration

Postgres

Postgres is a powerful, open source object-relational database system with over 30 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance.

The following settings are available via the Manifest file :

Option	Description	Clouds
`encoding`	Specify the encoding (AKA charset) for the database. Valid values can be found in the Postgres character set docs.	All
`groups`	Used to define multiple separate database groups (of the same type), each with their own configuration. The name of each group in your Manifest must match the names in your Dashboard.	All
`iam_instance_profile_name`	The name of the IAM instance profile that should be used when provisioning this server.	AWS
`instance_service_account_name`	The name of the GCE Service Account that should be used when provisioning this server.	GCE
`operating_system`	The version of Ubuntu to install on the server that hosts Postgres. Accepted values ubuntu2204orubuntu2404	All
`postgis`	Specify whether to include PostGIS	All
`postgis / version`	Specify the version of PostGIS you want to install. Must be nested in `postgres` settings	All
`root_disk_size`	Default size of root disk (in GB) for servers used by Postgres. Default value is `50`.	AWS, Azure, GCE
`root_disk_type`	Disk type for servers used by Postgres, accepted values being `ssd` and `magnetic`. Default value is `ssd`.	AWS, GCE
`tags`	Append the listed tags to any servers created for this component. See our tagging guide for more info on tag syntax and support.	AWS, Azure, DigitalOcean, Hetzner
`tamper_with_yml`	Determines whether Cloud 66 can automatically update your database configuration (username, password and server address). Default is `yes`.	All
`version`	Specify the version of Postgres you want to install. NOTE: You can use database groups to run different versions of the same database in parallel with each other.	All

Example YAML for Postgres

postgresql:
  configuration:
    iam_instance_profile_name: psql-perms
    version: 9.3.4
    encoding: ISO_8859_8
    postgis: true
    root_disk_size: 100
    root_disk_type: ssd

If you need help specifying multiple databases of the same type via your Manifest, please read our guide on Database Groups.

PostGIS

postgresql:
  configuration:
    postgis:
      version: 2.1.1