Setting up a Postgres streaming replica has a lot of advantages: hot backup, offloading analytics queries, and piece of mind. Using a simple bash script combined with Kamal, it's not too difficult to setup.
--------------------------------
Reference Links
Official Docs: https://www.postgresql.org/docs/curre...
Code sample: https://github.com/samcraigjohnson/si...
--------------------------------
My dead simple Kamal guide →
https://samcraigjohnson.gumroad.com/l...
Check out twitter for more: / samcraigjohnson
#rubyonrails #webdevelopment #postgresql #devops