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: 4241DBF0.3010505@commandprompt.com (view raw or flat)
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.

Sincerely,

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 - http://www.commandprompt.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-2014 The PostgreSQL Global Development Group