Copy schema from docker DB to remote RDS DB (going from development to production)

Hello,

I have a local docker environment with a docker Postgresql database. I am using this same DB set up for my staging environment hosted on EC2. However, for my production environment I will be hosting on EC2 in a docker container and would like to use an RDS Postgresql database. Is it possible to transfer my schema from my docker DB to my new RDS database? It seems like I will need to change a lot of server connect settings, etc for my live server. I’m happy to convert my local environment to the RDS database as well, but I do not see how to transfer the schema from docker DB to RDS DB. Thanks for your help.

1 Like