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 | Applied on | 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
If you need help specifying multiple databases of the same type via your Manifest, please read our guide on Database Groups.