Re: best way to make incremental back-ups?

From: Lee Harr <missive(at)frontiernet(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: best way to make incremental back-ups?
Date: 2003-02-17 23:25:04
Message-ID: b2rr0g$2ar4$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

In article <200302171913(dot)h1HJDnr17243(at)candle(dot)pha(dot)pa(dot)us>, Bruce Momjian wrote:
>
> Sorry, we will have point-in-time recovery in 7.4. Right now, the only
> solution is a async replication using something like /contrib/dbmirror
> or /contrib/rserv.
>
> ---------------------------------------------------------------------------
>
> Mel Jamero wrote:
>> Hi!
>>
>> What's the best way to make incremental back-ups?
>>
>> Is there a tool (GUI or otherwise, open source perhaps) for this?
>>
>> Red Hat Linux 7.2. PostgreSQL 7.1
>>

This may be really dumb, but would it be possible to do something
with pg_dump and diff ?

Especially if you use those special flags to pg_dump which tell it
to dump out just the table definitions or just the data....

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Ed Loehr 2003-02-17 23:46:05 Re: server won't shutdown
Previous Message Ed L. 2003-02-17 23:06:56 Re: please help--database just locks up.