Re: Backup - Mailing list pgsql-admin

From Jason Minion
Subject Re: Backup
Date
Msg-id 0105A1BF505D304E9E5AF38B63E40E4E69D29B@exchange.siglercompanies.com
Whole thread Raw
In response to Backup  ("Joseph M. Day" <jday@gisolutions.us>)
List pgsql-admin
If you are running version 8, you may want to look into the WAL archiving:

http://www.postgresql.org/docs/8.0/interactive/backup-online.html

That would form the basis of your incremental backup strategy. I haven't had the joy of using them myself however, and
donot 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
[mailto:pgsql-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

pgsql-admin by date:

Previous
From: "Joshua D. Drake"
Date:
Subject: Re: Backup
Next
From: "Jay A. Kreibich"
Date:
Subject: Re: Backup