Re: Pgbasebackup help - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: Pgbasebackup help
Date
Msg-id 1610052678.274994.1449176695004.JavaMail.open-xchange@oxweb02.ims-firmen.de
Whole thread Raw
In response to Re: Pgbasebackup help  (John R Pierce <pierce@hogranch.com>)
Responses Re: Pgbasebackup help  (Jim Nasby <Jim.Nasby@BlueTreble.com>)
List pgsql-general

> John R Pierce <pierce@hogranch.com> hat am 3. Dezember 2015 um 21:38
> geschrieben:
>
>
> On 12/2/2015 9:59 PM, Yelai, Ramkumar IN BLR STS wrote:
> >   I can't shutdown the database during the backup and unable to use file
> > system copy of data folder as it creates inconsistency
>
> If you invoke pg_start_backup()  before the copy, and pg_stop_backup()
> after the copy, then a file system copy is consistent.

file system snapshot PLUS transaction logs => consistent backup.


pgsql-general by date:

Previous
From: John R Pierce
Date:
Subject: Re: Pgbasebackup help
Next
From: Jim Nasby
Date:
Subject: Re: json indexing and data types