Re: Incremental Backup

From: Andrew Sullivan <andrew(at)libertyrms(dot)info>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: Incremental Backup
Date: 2003-08-21 14:49:03
Message-ID: 20030821144903.GB9803@libertyrms.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Tue, Aug 19, 2003 at 07:19:19PM -0500, theguardian(at)vsnl(dot)net wrote:
> So is there any way of doing some kind of incremental backup in
> which only the daily work which is done is backed up from the
> standalone machine and is appended into the data which is already
> existing over there on the server.

Not at the moment. You could use a replication system to solve this
for you, though. See contrib/rserv, the recent improvements to rserv
available on gborg (I haven't used them), contrib/dbmirror, or the
soon-to-be-released _other_ improvements to contrib/rserv.

A
--
----
Andrew Sullivan 204-4141 Yonge Street
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Andrew Sullivan 2003-08-21 14:53:03 Re: DBMirror - Replicating binary objects of type bytea ?
Previous Message Tom Lane 2003-08-21 14:28:19 Re: pg_dump does not dump index, constraints, sequences