Enviroment variable in pods deployed via PostgresqlOperator v5.0.4

[maleka12]

Overview

We want to add ENV to each pod deployed by postgrescluster crd. Is there any option to do that for every new deployed PostgresCluster by default?
By now the only way I found to achieve that is to set env to statefulset manually, after cluster is deployed.

Use Case

We want to set proper TimeZone by adding env TZ into containers.

Desired Behavior

Enviroment variable will be automatically added to any new instance of postgrescluster.

Environment

• Platform: OpenShift
• Platform Version: 4.8.29
• PGO Image Tag: ubi8-13.5-0
• Postgres Version: 13
• Storage: CEPH

[aleksey-dv]

+1
Could be very useful, for ex. additional env AWS_STS_REGIONAL_ENDPOINTS=regional to pgbackrest containers to assume role with access to S3 within local VPC STS endpoint

[benjaminjb]

Just writing to let you know that we have this issue in our backlog as it is a fairly common feature request.