My boss was asking about incremental backups.
I was scratching my head, thinking that the transaction log and a backup
policy (script) for each record set (sorry about the archaic terminology)
was the usual solution. But there is a some resistance against writing
more code, so I'm wondering what the current state of affairs with
postgresql in regards to incremental backup would be.
A quick search of the lists produced the following:
Bruce talks in November 2002 about plans for point-in-time recovery in v.
7.4, but last December says it isn't there yet.
Jan mentions Slony-I replication back last January.
Somebody threw in some chatter about XLog.
Scott metioned briefly last August the possibility of combining a live
data server with an archive server, or of using a daily schema.
What's the typical user doing for incrementals, besides going to a
commercial server?
--
Joel Matthew <rees@ddcom.co.jp>