Re: Backups

Поиск
Список
Период
Сортировка
От Aldo Sarmiento
Тема Re: Backups
Дата
Msg-id CAHX=r6yPw-AirfnRCMG=NrTyRM0O9_HHiSCYS9r_ZU+XNaX=hQ@mail.gmail.com
обсуждение исходный текст
Ответ на Backups  (Azimuddin Mohammed <azimeiu@gmail.com>)
Список pgsql-admin
Дерево обсуждения
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 по дате отправления:

Предыдущее
От: Azimuddin Mohammed
Дата:
Сообщение: Backups
Следующее
От: "Saeed Ahmed (DB)"
Дата:
Сообщение: POSTGRESQL 10 Media download with CHECKSUM VALUE