Re: Is there a continuous backup for pg ?

Поиск
Список
Период
Сортировка
От Gary M
Тема Re: Is there a continuous backup for pg ?
Дата
Msg-id CAGwOJnxt9me3czwkAi+XQG44KR0Z0+dqDnXtN3SZd7YDZg5bpA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Is there a continuous backup for pg ?  ("Joshua D. Drake" <jd@commandprompt.com>)
Ответы Re: Is there a continuous backup for pg ?
Список pgsql-general
Thanks Josh,

PITR is the option I was recommending. Project management diligence dictates I need at least one other option from a different recommending source, two other options optimally. 

On Fri, Mar 2, 2018 at 12:16 PM, Joshua D. Drake <jd@commandprompt.com> wrote:
On 03/02/2018 11:05 AM, Gary M wrote:
Hi,

I have an unusual requirement for schema based, live backup of a 24/7 database processing 100K inserts/updates per hour. The data store is around 100TB.

The requirement is supporting an incremental backup of 10 minute windows.  Replication is not considered backup from malicious action.

Are there any best practices or solutions that can meet these requirements ?

A cold standby using PITR?

JD


b/r
gary


--
Command Prompt, Inc. || http://the.postgres.company/ || @cmdpromptinc

PostgreSQL centered full stack support, consulting and development.
Advocate: @amplifypostgres || Learn: https://postgresconf.org
*****     Unless otherwise stated, opinions are my own.   *****


В списке pgsql-general по дате отправления:

Предыдущее
От: Steve Atkins
Дата:
Сообщение: Re: Is there a continuous backup for pg ?
Следующее
От: David Steele
Дата:
Сообщение: Re: Is there a continuous backup for pg ?