Re: Problem with Online-Backup - Mailing list pgsql-general

From Richard Huxton
Subject Re: Problem with Online-Backup
Date
Msg-id 45C3042C.8030105@archonet.com
Whole thread Raw
In response to Re: Problem with Online-Backup  (roopa perumalraja <roopabenzer@yahoo.com>)
List pgsql-general
roopa perumalraja wrote:
> Thanks a lot for your reply. To make it more clear will the be no
> loss of data or data corruption when taking a base backup while there
> is inserts & updates happening in the database?

Updates to the database continue uninterrupted.

The base backup alone is *not* enough to be safe.

The base backup  + WAL segments *are* enough to be safe.

--
   Richard Huxton
   Archonet Ltd

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: Defining and Using variables in a postgres function
Next
From: "Hakan Kocaman"
Date:
Subject: Re: Functions, composite types and Notice