Question about create user & alter user password #4420
Description
According to our audit requirements, the user password creation process and the password modification process must be separated and cannot be handled together.
For the Operator, if we modify the WriteUsersInPostgreSQL method to separate password modification and user creation into two different transactions, are there any risks?
If we use two-phase commit (2PC), would there be any issues?
Environment
Please provide the following details:
Platform: Kubernetes
Platform Version: 1.29.7
PGO Image Tag: postgres-operator:ubi9-5.8.5-0
Postgres Version:17.7