sassoftware / viya4-iac-gcp

This project contains Terraform configuration files to provision infrastructure components required to deploy SAS Viya platform products on Google Cloud
Apache License 2.0
21 stars 17 forks source link

feat: (IAC-705) Update default PostgreSQL server_version to 13 #141

Closed jarpat closed 2 years ago

jarpat commented 2 years ago

Changes

Changes the default value for the server_version variable which is contained within the postgres_server_defaults map to 13. The user can select any version between 11-14 to suite their SAS Viya deployment requirements.

Tests

Ran through the following deployment scenarios to test out PG

Scenario Provider K8s Version PG Version Order Cadence Deployment Stabilized Notes
PostgreSQL V11 GCP v1.23.8-gke.1900 11.16 * Fast:2020 Yes
PostgreSQL V12 GCP v1.23.8-gke.1900 12.11 * Fast:2020 Yes
PostgreSQL V13 GCP v1.23.8-gke.1900 13.7 * Fast:2020 Yes New default, did not define server_version in .tfvars
PostgreSQL V14 GCP v1.23.8-gke.1900 14.4 * Fast:2020 Yes