Hi! everibody! Could you help me? I need to create...
# general
n
Hi! everibody! Could you help me? I need to create some database in a Instance RDS. I could create them by setting temporally, the private subnet (where RDS is located) to a public subnet by associate the routeTable with igw. The issue now is I can't disassociate the public routeTable of the subnet and assign the private one again. Thanks a lot.
l
Not sure if it matches your use case, but we use the Pulumi Automation API for this. We have a stack that creates the database in a private subnet, along with a bastion host that is accessible via SSM in the public subnet. Then we establish a tunnel using SSM/the bastion host and run a second stack that uses that tunnel to connect to the database, using the PostgreSQL provider to create logical databases, etc.