Postgres Pro
Downloads
Home   >   mailing lists

Re: Backups - Mailing list pgsql-admin

From Aldo Sarmiento
Subject Re: Backups
Date
Msg-id CAHX=r6yPw-AirfnRCMG=NrTyRM0O9_HHiSCYS9r_ZU+XNaX=hQ@mail.gmail.com
Whole thread Raw
In response to Backups  (Azimuddin Mohammed <azimeiu@gmail.com>)
List pgsql-admin
Tree view
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@gmail.com> wrote:
Hello admins,
What is thr best backup strategy?
I am planning to setup my pg cluster with streaming replication.
My criteria 
1. 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.

pgsql-admin by date:

Previous
From: Azimuddin Mohammed
Date:
Subject: Backups
Next
From: "Saeed Ahmed (DB)"
Date:
Subject: POSTGRESQL 10 Media download with CHECKSUM VALUE