Skip site navigation (1) Skip section navigation (2)

Re: Backup

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: "Joseph M(dot) Day" <jday(at)gisolutions(dot)us>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Backup
Date: 2005-03-23 21:13:20
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
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.

If you are using >8.0 You could use the PITR functionality.


Joshua D. Drake

> Thanks,
> Joe,
> --------------------------------------------
> Joseph M. Day
> Global Innovative Solutions

Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-667-4564 - jd(at)commandprompt(dot)com -
PostgreSQL Replicator -- production quality replication for PostgreSQL

Attachment: jd.vcf
Description: text/x-vcard (285 bytes)

In response to

  • Backup at 2005-03-23 20:41:35 from Joseph M. Day

pgsql-admin by date

Next:From: Jason MinionDate: 2005-03-23 21:15:49
Subject: Re: Backup
Previous:From: Joseph M. DayDate: 2005-03-23 21:01:46
Subject: Re: Backup

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group