https://pulumi.com logo
#general
Title
# general
n

numerous-carpenter-4252

02/26/2024, 11:22 AM
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

lively-crayon-44649

02/26/2024, 11:24 AM
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.