Connection pooler not working when DB in VPC

[GabriFila]

Hi!
First of all, thank you for working on this provider 😍
I tried the latest version to test the CRUD of the connection pooler, it works fine except when the DB is in a VPC

The Terraform output is

{
    "connection_pooler_enabled": true,
    "enable_ha_replica": false,
    "hostname": "REDACTED.REDACTED.vpc.tsdb.forge.timescale.com",
    "id": "REDACTED",
    "memory_gb": 2,
    "milli_cpu": 500,
    "name": "REDACTED",
    "password": "REDACTED",
    "pooler_hostname": "",
    "pooler_port": 39454,
    "port": 5432,
    "read_replica_source": null,
    "region_code": "REDACTED",
    "storage_gb": null,
    "timeouts": null,
    "username": "tsdbadmin",
    "vpc_id": "REDACTED"
  }

where the pooler hostname is "" and the port doesn't reflect the Timescale UI information.
The UI for the pooler shows hostname similar to the non-pooler one (only with -pooler inside) and a port 5432 instead of the one returned from terraform

If you need any other info let me know

[Khyme]

Thank you for your feedback, looking into it!

[shababq]

facing this same issue i have added more details in this link
#142 (comment)