| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Carl Karsten <carl(at)personnelware(dot)com> |
| Cc: | Martin Mueller <martinmueller(at)northwestern(dot)edu>, "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: a back up question |
| Date: | 2017-12-05 23:05:03 |
| Message-ID: | 20171205230503.wqqvxhse27wtw4xd@alvherre.pgsql |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Carl Karsten wrote:
> On Tue, Dec 5, 2017 at 4:15 PM, Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ahmed, Nawaz | 2017-12-05 23:26:06 | RE: Replica on low-bandwitdh network |
| Previous Message | John R Pierce | 2017-12-05 22:55:41 | Re: a back up question |