»PostgreSQL Requirements for Terraform Enterprise
Note: These requirements apply to the External Services operational mode, not the Mounted Disk operational mode. Refer to the Pre-Install Checklist for more information.
To use an external PostgreSQL database with Terraform Enterprise, the following requirements must be met:
- A PostgreSQL server such as Amazon RDS for PostgreSQL or a PostgreSQL-compatible server such as Amazon Aurora PostgreSQL must be used.
- The PostgreSQL server version must be one of the following:
- 10.x, 11.x, 12.x
- A PostgreSQL user must be created with the following permissions on the database:
- The ability to create, modify, and read all tables and indices on all schemas within the database. Usually this is granted if the user is an owner of the database.
- The ability to create extensions. If it is not feasible to have a user with the "CREATE EXTENSION" privilege, then refer to the Creating Extensions section below for information on creating the necessary extensions.
registryPostgreSQL schemas must be created on the database. In Terraform Enterprise v201911-1 and later, these schemas will be automatically created if they do not already exist. For Terraform Enterprise v201910-1 and earlier, these schemas must be manually created as detailed in the Creating Schemas section below.
Note: This section can be skipped if installing Terraform Enterprise v201911-1 or later as the required database schemas will be automatically created by the Terraform Enterprise application.
If installing Terraform Enterprise v201910-1 or earlier, the database schemas
must be manually created. To create database schemas manually, the
CREATE SCHEMA command can be used. Execute the following snippet on the
PostgreSQL database to create the required database schemas manually:
CREATE SCHEMA IF NOT EXISTS rails; CREATE SCHEMA IF NOT EXISTS vault; CREATE SCHEMA IF NOT EXISTS registry;
If the configured PostgreSQL user does not have permission to create PostgreSQL extensions (i.e. is not a superuser), then run the following SQL commands to create the proper extensions:
CREATE EXTENSION IF NOT EXISTS "hstore" WITH SCHEMA "rails"; CREATE EXTENSION IF NOT EXISTS "uuid-ossp" WITH SCHEMA "rails"; CREATE EXTENSION IF NOT EXISTS "citext" WITH SCHEMA "registry";
When providing optional extra keyword parameters for the database connection,
note an additional restriction on the
sslmode parameter is that only the
, and disable
values are allowed. For
installations in External Services mode , the default value ofsslmode
. For installations in Mounted Disk mode, the default value of
is set todisable`.
Note: See the PostgreSQL library documentation for more about extra parameters related to sslmode. Terraform Enterprise provides a certificates file at
/tmp/cust-ca-certificates.crt, which is required by the
verify-ca modes. Additional certificates can be added via the CA Custom Bundle setting.
Note: The Client Certificates configuration is currently not supported by Terraform Enterprise due to the limitation of storing certificate files for the
sslkey connection parameters.
»PostgreSQL 9.5 to 12 Upgrade
In Terraform Enterprise v202103-1, the internally-managed PostgreSQL server was been upgraded from PostgreSQL 9.5 to PostgreSQL 12. This change only affected installations in Mounted Disk mode.
For more details, consult the v202103-1 release notes.