If you are running version 8, you may want to look into the WAL archiving:

http://www.postgresql.org/docs/8.0/i...up-online.html

That would form the basis of your incremental backup strategy. I haven't had the joy of using them myself however, and do not know of any tools to make it more convenient, and a quick breeze through pgfoundry didn't find much either.

-----Original Message-----
From: pgsql-admin-owner@postgresql.org
[mailtogsql-admin-owner@postgresql.org]On Behalf Of Joseph M. Day
Sent: Wednesday, March 23, 2005 3:02 PM
To: 'Naomi Walker'
Cc: pgsql-admin@postgresql.org
Subject: Re: [ADMIN] Backup


Joseph M. Day wrote:
>> I am trying to convert a MSSQL DB thats roughly 45GB, to Postgres. I
>> am
>> trying to find the equivalent of Full / Incremental / Differential
>> backups. It looks like pg_dump is the equivalent of a full backup,
but
>> how do I keep the equivalent of a Incremental, or Differential
backup.
>>
>> To keep the same functionality, I will need a full backup once a
week,
>> and a differential once a day.
>>
>At this time, there is nothing less than full backups.

--


Thanks Naomi.

Is there anybody using this for large DB's? Anything larger than a
couple hundred GB, it would be impractical to make full backups
everyday. Anyone out there using this for large DB's, if so I'd love to
hear how they are dealing with backups.

Joe,




---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly