incremental backups?

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>

Responses

Browse pgsql-general by date

  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?