I have 1 DB called - DB_A. I would like to create read only database DB_B from DB_A which updates itself every 10 mins. Is their any easy way to do it in postgres? I am using Postgres 11. Also any data deleted from DB_A should get removed from DB_B on next update.


It sounds like you want the recovery_min_apply_delay option of streaming replication.

This will give you a rolling 10 minute window, not a leaping window.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.