I'm currently looking at creating a follower db of a live production database. The follower will be used for analytics purposes only. And will not be inserting any data - if it did then it would be by mistake.

After reading the docs on heroku https://devcenter.heroku.com/articles/heroku-postgres-follower-databases#create-a-follower

I cannot see how you could prevent changes from a follower creeping back into the master db.

Any suggestions or pointers will be very helpful. Thank you.

  • 2
    Just a few rows above the anchor you linked: 'A database follower is a read-only copy of the master database that stays up-to-date with the master database data.' You simply cannot change there anything. – dezso Apr 30 '15 at 14:15
  • 1
    @dezso That should be the answer. – BalinKingOfMoria Feb 18 '16 at 21:30

Your Answer

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

Browse other questions tagged or ask your own question.