Re: a back up question - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: a back up question
Date
Msg-id 20171205230503.wqqvxhse27wtw4xd@alvherre.pgsql
Whole thread Raw
In response to Re: a back up question  (Carl Karsten <carl@personnelware.com>)
List pgsql-general
Carl Karsten wrote:
> On Tue, Dec 5, 2017 at 4:15 PM, Alvaro Herrera <alvherre@alvh.no-ip.org>
> wrote:

> > A backup generated by pg_dump never includes writes that are in flight
> > while the backup is being taken.  That would make the backup absolutely
> > worthless!
> 
> Hmm, i kinda glossed over my point:
> if you come up with your own process to chop up the backup into little
> pieces, you risk letting writes in, and then yeah, worthless.

Ah, sure.

-- 
Álvaro Herrera                https://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: a back up question
Next
From: "Ahmed, Nawaz"
Date:
Subject: RE: Replica on low-bandwitdh network