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.
http://www.postgresql.org/docs/8.2/static/continuous-archiving.html
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?
Not sure I understand you here.
--
Richard Huxton
Archonet Ltd
