I have had lots of success using streaming replication for potential failover as well as read only hot stand by to assist with my master db.
Additionally we use pg backrest for PITR in the event that we need to roll back for some unforeseen reason (hacking, corruption, etc).
Aldo Sarmiento
President & CTO
8687 Research Dr, Irvine, CA 92618
On Thu, Jan 18, 2018 at 6:16 PM, Azimuddin Mohammed <azimeiu@xxxxxxxxx> wrote:
Hello admins,What is thr best backup strategy?I am planning to setup my pg cluster with streaming replication.My criteria1. I should not be restarting my master server and slave.2. Shiuld take a huge performace cpu or memory (Ram) consumption.3. Compression is ok.
