RDS Postgres Module Providing Null Output for DB Hostname

[HarshitSF]

Describe the bug
When we are creating an RDS postgres DB instance using the ARC IAC module it provides a null output value for rds_instance_hostname which we pass to another terraform module as the hostname to connect with the DB instance for automatic creation of databases.

To Reproduce
Steps to reproduce the behavior:

1. Use the RDS Postgres module for arc DB and create output. tf file
   

2. Run the terraform init, plan & apply to see the output.
   

3. See the output rds_instance_hostname which is giving null value.

Expected behavior
It should give the hostname of the rds instance.

[tsaucier-sf]

@mayank0202 @vijay-stephen, I believe this is an issue with the upstream provider we are referencing because we are not passing in a dns_zone_id as outlined here: https://github.com/cloudposse/terraform-aws-rds/blob/main/main.tf#L228 (where the hostname is derived from).

Please add support for this feature in our module.

@HarshitSF, in the absence of this output, the module is defaulting to the AWS endpoint as the hostname. Please use trimsuffix(module.rds_postgres.rds_instance_endpoint, ":5443") in the interim to pass in to your other module.

[HarshitSF]

@tsaucier-sf Thanks for your suggestion. Currently, I am following the same approach.