Add server parameters to azurerm_postgresql_flexible

Terraform Providers Azure
1

I can’t find in the terraform docs how to manage azure postgresql flexible server parameters Server parameters - Azure Database for PostgreSQL - Flexible Server | Microsoft Docs

Is that feature even exists?

1 Like
2

From what I can tell you do it through the postgresql_flexible_server_configuration resource

3

Yes, I can confirm that you can change almost any postgresql settings, as stated in the documentation:

name - (Required) Specifies the name of the PostgreSQL Configuration, which needs to be a valid PostgreSQL configuration name. Changing this forces a new resource to be created.

You can check the settings on PostgreSQL: Documentation: 14: Chapter 20. Server Configuration . You can also look from the Azure portal, open your server’s overview, then browse the settings in the “server parameters” section. It doesn’t hurt to do this because some settings are “locked” so the terraform apply may fail.