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 - [EMAIL PROTECTED] - http://www.commandprompt.com PostgreSQL Replicator -- production quality replication for PostgreSQL
begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:[EMAIL PROTECTED] title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 x-mozilla-html:FALSE url:http://www.commandprompt.com version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
