From: | Joel Matthew <rees(at)ddcom(dot)co(dot)jp> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | incremental backups? |
Date: | 2004-06-23 03:28:27 |
Message-ID: | 20040623120901.EA2F.REES@ddcom.co.jp |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)ddcom(dot)co(dot)jp>
From | Date | Subject | |
---|---|---|---|
Next Message | Vams | 2004-06-23 03:46:38 | Parameters from trigger to function. |
Previous Message | Madison Kelly | 2004-06-23 03:26:58 | Datatype sizes; a space and speed issue? |