incremental backup

From: "postgresql" <postgresql(at)db(dot)pku(dot)edu(dot)cn>
To: pgsql-hackers(at)postgreSQL(dot)org <pgsql-hackers(at)postgreSQL(dot)org>
Subject: incremental backup
Date: 2003-06-10 12:14:37
Message-ID: 200306101956968.SM01120@gaojun
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Browse pgsql-hackers by date

  From Date Subject
Next Message Teodor Sigaev 2003-06-10 12:45:20 Function returns composite type
Previous Message Nigel J. Andrews 2003-06-10 10:58:59 Re: Proposal to Re-Order Postgresql.Conf, part II