Обсуждение: Backups

Поиск
Список
Период
Сортировка

Backups

От
Azimuddin Mohammed
Дата:
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.

Re: Backups

От
Aldo Sarmiento
Дата:
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.