[BUG] ... Error: Error connecting to PostgreSQL server (scheme: postgres): XXXXdXXXXial tcp 127.0.0.1:5432: connect: connection refused

[leonavevor]

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 "me too" comments, 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

1.6.6

AzureRM Provider Version

7.3.0

Affected Resource(s)/Data Source(s)

postgres flexible server deployment

Terraform Configuration Files

in the process of postgres db creation, terraform fails right after apply the firewall filters.

such as making more configurations after postgres flexible server is deployed.
For example the following configuration wouldn't complete and fails after the firewall filters are applied.


module "postgresql_users" {
  source  = "claranet/users/postgresql"
  version = "6.0.0"

  for_each = module.postgresql_flexible.postgresql_flexible_databases_names
  administrator_login = module.postgresql_flexible.postgresql_flexible_administrator_login
  database = each.key
}

module "postgresql_configuration" {
  source  = "claranet/database-configuration/postgresql"
  version = "6.0.0"

  for_each = module.postgresql_flexible.postgresql_flexible_databases_names

  administrator_login = module.postgresql_flexible.postgresql_flexible_administrator_login
  database_admin_user = module.postgresql_users[each.key].user
  database            = each.key
  schema_name         = each.key
}

Debug Output/Panic Output

module.accelerator.module.postgresql_flexible.azurerm_postgresql_flexible_server_firewall_rule.firewall_rules["0"]: Still creating... [30s elapsed]
module.accelerator.module.postgresql_flexible.azurerm_postgresql_flexible_server_firewall_rule.firewall_rules["0"]: Still creating... [40s elapsed]
module.accelerator.module.postgresql_flexible.azurerm_postgresql_flexible_server_firewall_rule.firewall_rules["0"]: Still creating... [50s elapsed]
module.accelerator.module.postgresql_flexible.azurerm_postgresql_flexible_server_firewall_rule.firewall_rules["0"]: Still creating... [1m0s elapsed]
module.accelerator.module.postgresql_flexible.azurerm_postgresql_flexible_server_firewall_rule.firewall_rules["0"]: Creation complete after 1m2s [id=/subscriptions/xxxxxxxxxxxxxxxx/resourceGroups/rg-fgeasf9/providers/Microsoft.DBforPostgreSQL/flexibleServers/psqlf-default-stack-bla-dev/firewallRules/0]
╷
│ Error: Error connecting to PostgreSQL server  (scheme: postgres): XXXXdXXXXial tcp 127.0.0.1:5432: connect: connection refused
│ 
│   with module.accelerator.module.postgresql_configuration["main_db"].postgresql_grant.revoke_public,
│   on .terraform/modules/accelerator.postgresql_configuration/r-psql-db-config.tf line 1, in resource "postgresql_grant" "revoke_public":
│    1: resource "postgresql_grant" "revoke_public" {
│ 
╵

Expected Behaviour

should apply the firewall filter as the last process so that other operations are not blocked.

Actual Behaviour

fails in the middle of deployment

Steps to Reproduce

No response

Important Factoids

No response

References

No response

[Shr3ps]

Hello,

how did you configure the postgresql provider? did you use the code we have in our examples?

If you look at your error, the provider is trying to connect to 127.0.0.1 (which is not related to firewall settings...)