Re: Pgbasebackup help

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: John R Pierce <pierce(at)hogranch(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: Pgbasebackup help
Date: 2015-12-03 21:04:54
Message-ID: 1610052678.274994.1449176695004.JavaMail.open-xchange@oxweb02.ims-firmen.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> John R Pierce <pierce(at)hogranch(dot)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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Nasby 2015-12-03 22:09:55 Re: json indexing and data types
Previous Message John R Pierce 2015-12-03 20:38:09 Re: Pgbasebackup help