It is my understanding that once a standby server has reached the point where it is often waiting for wal files to replay, it is pretty much caught up to the primary server, with the differences being in whatever wal files are currently in queue to be archived by the primary. If I'm correct, then for large databases wherein it can take hours to take a base backup, is there anything to be gained by using incrementally updated backups?

Erik Jones

Software Developer | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)

Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com



---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to