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