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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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 | Content-Type | Size |
---|---|---|
jd.vcf | text/x-vcard | 285 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Jason Minion | 2005-03-23 21:15:49 | Re: Backup |
Previous Message | Joseph M. Day | 2005-03-23 21:01:46 | Re: Backup |