Re: 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.


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