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?
--
Roopa
Richard Huxton <dev@archonet.com> wrote:
roopa perumalraja wrote: > Hi all, > > While there are inserts & updates happening into the database, is it > possible to make the base backup without losing any of the updates in > the database?
Yes, that's the whole point of PITR. The filesystem backup + WAL files gives you a working database when restored.
> What does select pg_start_backup('label'); & pg_stop_backup(); do > actually?
Tell the server that you are taking a backup, start a new WAL segment for you too.
> I am worried if the file system backup tool will not store the data > files in the /pgsql/data/base which is still getting populated. Or > does the segment file store that?
