Deploying and configuring Postgres server in Azure with Terraform

Question

I'm deploying Azure Postgres Flexible Server with Terraform as described in GitHub. The configuration works as expected, no issues there. The only divination from that GitHub template is that I want to configure pgBouncer for Postgres which is now supported natively. I don't see a way how I can create this configuration (i.e., enable this feature).

I've done some research and discovered the configuration feature is not quite available (at least according to the open ticket in GitHub here). At the same time, one of the published replies suggests using azurerm_postgresql_flexible_server_configuration and this resource type is available in Terraform indeed. However, Microsoft documentation states that to enable and configure pgBouncer I need to introduce 7 parameters. I thought that to make the code tidier, I can use a list and foreach loop, like this:

locals {
  pg_config = {
    "pgbouncer.default_pool_size" : "50",
    "pgBouncer.max_client_conn"   : "5000",
    "pgBouncer.pool_mode"         : "TRANSACTION"
    etc...
  }
}

resource "azurerm_postgresql_flexible_server_configuration" "postgres_fs_config" {
  for_each = local.pg_config
  name = each.key
  value = each.value
  server_id = azurerm_postgresql_flexible_server.postgres-fs.id
}

Is this the best way to configure Postgres (without involving CDK)? Did I miss something?

John Bull · Accepted Answer · 2022-07-14 13:31:17Z

1

Ok, I verified this approach and it works like a charm. Will stick to it for now.

answered Jul 14, 2022 at 13:31

John Bull

1,1391 gold badge14 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Deploying and configuring Postgres server in Azure with Terraform

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related