Unable to update db_parameter_group's shared_preload_library to use two preload libraries

[omada-jacob-smith]

Community Note

• Please vote on this issue by adding a 👍 reaction to the original issue to help the community and maintainers prioritize this request
• Please do not leave "+1" or other comments that do not add relevant new information or questions, they generate extra noise for issue followers and do not help prioritize the request
• If you are interested in working on this issue or have submitted a pull request, please leave a comment

Terraform Version

$ terraform -v Terraform v0.12.20

• provider.aws v2.49.0

Affected Resource(s)

aws_db_parameter_group (resource)

Terraform Configuration Files

resource "aws_db_parameter_group" "db_params" {
  name   = "foo"
  family = "postgres11"

  parameter {
    name         = "shared_preload_libraries"
    value        = "pglogical,pg_stat_statements"
    apply_method = "pending-reboot"
  }
}

Expected Behavior

I should be able to use both pg_stat_statements and pglogical

Actual Behavior

The parameter group seems to be stuck on pg_stat_statements and only pg_stat_statements

Steps to Reproduce

First, we were only using "pglogical" and that worked, then we updated the parameter to be "pglogical,pg_stat_statements". We ran a plan/apply and then only pg_stat_statements was in the parameter group. I tried setting it back to pglogical only and it still is pg_stat_statements. The only way that I could get the values to work and for terraform to be content is to manually update the AWS UI. This has happened on four different databases/pg groups in exactly the same way.

Important Factoids

Not that I know of.

[jfirebaugh]

I see the same behavior with "auto_explain,pg_stat_statements".

[justinretzolk]

Hey @omada-jacob-smith 👋 Thank you for taking the time to file this issue. Given that there's been a number of Terraform and AWS Provider releases since you initially filed this, can you confirm whether you're still experiencing the same behavior?

[github-actions[bot]]

Marking this issue as stale due to inactivity. This helps our maintainers find and focus on the active issues. If this issue receives no comments in the next 30 days it will automatically be closed. Maintainers can also remove the stale label.

If this issue was automatically closed and you feel this issue should be reopened, we encourage creating a new issue linking back to this one for added context. Thank you!

[github-actions[bot]]

I'm going to lock this issue because it has been closed for 30 days ⏳. This helps our maintainers find and focus on the active issues. If you have found a problem that seems similar to this, please open a new issue and complete the issue template so we can capture all the details necessary to investigate further.