Re: Backup - Mailing list pgsql-admin

From Joshua D. Drake
Subject Re: Backup
Date
Msg-id 4241DBF0.3010505@commandprompt.com
Whole thread Raw
In response to Backup  ("Joseph M. Day" <jday@gisolutions.us>)
List 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@commandprompt.com - http://www.commandprompt.com
PostgreSQL Replicator -- production quality replication for PostgreSQL


Attachment

pgsql-admin by date:

Previous
From: "Joseph M. Day"
Date:
Subject: Re: Backup
Next
From: "Jason Minion"
Date:
Subject: Re: Backup