From: | Gary M <garym(at)oedata(dot)com> |
---|---|
To: | |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Is there a continuous backup for pg ? |
Date: | 2018-03-02 20:44:52 |
Message-ID: | CAGwOJnw_L7VwfX+83W5Ctn2AdHum+fECAfcKAZEtoHpeBHuncA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Thanks everyone !!
I think I have enough alternatives for this project. I'll start testing on
Monday..
have a good weekend
-g
On Fri, Mar 2, 2018 at 12:55 PM, David Steele <david(at)pgmasters(dot)net> wrote:
> Hi Gary,
>
> On 3/2/18 2:05 PM, 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 ?
> pgBackRest is specifically designed to handle very large clusters and
> high WAL rates. Backup, restore, and archiving can be run in parallel
> to speed operations. The new version 2 has been optimized to make
> archive-push even faster than version 1 and we will be releasing an
> optimized archive-get soon.
>
> You would be best off achieving your 10-minute windows with daily
> incremental backups and then recovery with PITR to the required time.
> PITR allows you to specify any time for recovery.
>
>
> Regards,
> --
> -David
> david(at)pgmasters(dot)net
>
From | Date | Subject | |
---|---|---|---|
Next Message | Paul Costello | 2018-03-02 21:32:13 | Jira database won't start after disk filled up |
Previous Message | Andres Freund | 2018-03-02 20:36:41 | Re: PQConsumeinput stuck on recv |