Re: best way to make incremental back-ups? - Mailing list pgsql-admin

From Lee Harr
Subject Re: best way to make incremental back-ups?
Date
Msg-id b2rr0g$2ar4$1@news.hub.org
Whole thread Raw
In response to Re: best way to make incremental back-ups?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
In article <200302171913.h1HJDnr17243@candle.pha.pa.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....


pgsql-admin by date:

Previous
From: "Ed L."
Date:
Subject: Re: please help--database just locks up.
Next
From: Ed Loehr
Date:
Subject: Re: server won't shutdown