I have a production and staging environments for my application. I am using Postgres (RDS instance) and Django. I want to sync my staging postgres database with production database.
Actually I want to know the best and efficient practices to have same data on both databases (prod and staging). Is there any syncing or replication process that resolve my issue? I don't want to spend my time daily on taking dump from one database and restore in another. I would be very happy if there is something real time replication of data or scheduled replication after 6 or 8 hours. Kindly share your thought on this.