pgAdmin on Openshift Security Context error

[Beembeem01]

Please ensure you do the following when reporting a bug:

• Provide a concise description of what the bug is.
• Provide information about your environment.
• Provide clear steps to reproduce the bug.
• Attach applicable logs. Please do not attach screenshots showing logs unless you are unable to copy and paste the log data.
• Ensure any code / output examples are properly formatted for legibility.

Note that some logs needed to troubleshoot may be found in the /pgdata/<CLUSTERNAME>/pg_log directory on your Postgres instance.

An incomplete bug report can lead to delays in resolving the issue or the closing of a ticket, so please be as detailed as possible.

If you are looking for general support, please view the support page for where you can ask questions.

Thanks for reporting the issue, we're looking forward to helping you!

Overview

pgAdmin CRs creates StatefulSet with low numbered fsGroup configuration. In order to solve that on PostgresCluster there is a flag (openshift: true) that flag is missing from pgAdmin.

Environment

Please provide the following details:

• Platform: OpenShift
• Platform Version: 4.14
• PGO Image Tag: ubi8-5.7.1-0
• Postgres Version 16
• Storage: sphere-csi

Steps to Reproduce

Create Multiple pgAdmin CRs in order to have at least one of them with low numbered fsGroup config on the StatefulSet.

REPRO

Provide steps to get to the error condition:

1. Run ...
2. Do ...
3. Try ...

EXPECTED

The pods will run without problems.
Or adding openshift: true to the CR will solve that problem.

ACTUAL

The pods aren't created because of missing SecurityContextContraints.
The CR doesn't accept the openshift: true flag.

Logs

Please provided appropriate log output or any configuration files that may help troubleshoot the issue. DO NOT include sensitive information, such as passwords.

Additional Information

Please provide any additional information that may be helpful.