Hi Everyone, can anybody help me with properly configuring my Strapi into RDS Postgres in AWS.
I have stablished connection, able to login on strapi admin in my local machine, however whenever I add an entry into a collection, I noticed that it gets saved into the database twice. It is saving two times in database.
Appreciate if you can advice how to fix, or if I am doing something wrong.
Thanksm Everyone
This topic has been created from a Discord post (1291668214857859114) to give it more visibility.
It will be on Read-Only mode here.
Join the conversation on Discord
hey, i know this is not a solution but actually i have been meaning to achieve the same goal
Can you please tell me how to configure strapi with postgres rds in AWS, how to get started
Hi Actually i figured out already the answer to my question, it is normal for strapi to store two identical entries on the database due to its draft and publish workflow in saving entries.
Regarding the your question, You just need to create an account in Amazon Web Services, and create an RDS postgres database, it straight forward when you are on the wizard. after the creation, just changed the connection string on your strapi project to your endpoint in RDS. Make sure your RDS is on Public for outside access.
Having RDS being public is not the ideal except if you TLS auth.
what’s the alternative for this public RDS then?
Well the closest to your Strapi install the better. You didn’t say where you will be publishing it. If it’s just for dev right now, why not just pop a pg container locally?