I created a local docker development with a docker Postgres database. Everything was great. I created an EC2 and launched a docker staging environment. All good. However, for production, I need my database to be AWS RDS Postgres. I created another EC2 with docker deployment, set up my RDS database. Since I couldn’t figure out how to migrate my schema from my development docker DB I re-created it in the new remote database (I could not apply changes like I could for my docker DB in the staging environment). I then had to change all of my server connect API actions to reflect the new database.
Now things get messy. When I try to use my development docker, it will not log in to my site, because my server connect actions are all looking at my AWS database to work. If I try to change the target of my development database to the new AWS RDS database, I get the following error when I try to deploy:
There has to be a better way to go from development to live database. I have not seen any tutorials that have helped me understand this issue. Would love some advice!
Last updated: