Preserve Ownership for PostgreSQL Service Accounts in Terraform
As a user managing PostgreSQL service accounts through Terraform,
I want to ensure that enabling the replication option using your Terraform provider does not lead to the recreation of the service account.
This way, the service account can retain its ownership and privileges over database objects such as tables and functions, avoiding potential disruptions.
Additionally, maintaining ownership and privileges is crucial for seamless operation and consistency in our database management processes.
SRE
shared this idea
-
Hey there 👋
This looks like a potential bug to me, are you sure if this is a suggestion rather than a bug?
If you would like to raise this as a bug, it would be really helpful for our team if you could post it to the GitHub Issues page of our Terraform provider, which is available over here: https://github.com/aiven/terraform-provider-aiven/issues.
Thank you!
-
SRE
commented
If I use the web console and enable replication, it looks like the service account keeps its ownership and privileges.