Thread: incremental backup

incremental backup

From
"postgresql"
Date:
Hi all.

I am newer to postgresql develop, so my qestion maybe too simple.

I have noticed that we have discussed the incremental backup and PITR before.

Frankly, I am still interested in incremental backup. I am not sure
whether we can implement such function based on XLog

Since there exists the unqiue LSN in XLog, if we backup the xlog content after
the given LSN, when some error ocurrs, we use the parital xlog to restore the 
database. 

I am not familiar with the log mechinism in postgresql, maybe before we make 
incremental backup on Xlog, we should create a checkpoints in log. 
Very appreciate to any kind feedback.

Thanks