Re: Problem with Online-Backup

From: Richard Huxton <dev(at)archonet(dot)com>
To: roopa perumalraja <roopabenzer(at)yahoo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Problem with Online-Backup
Date: 2007-02-02 09:28:12
Message-ID: 45C3042C.8030105@archonet.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Hakan Kocaman 2007-02-02 10:10:58 Re: Functions, composite types and Notice
Previous Message Alban Hertroys 2007-02-02 09:17:50 Re: Defining and Using variables in a postgres function