X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3C13A535BB for ; Wed, 23 Mar 2005 21:13:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 27447-09 for ; Wed, 23 Mar 2005 21:13:24 +0000 (GMT) Received: from hosting.commandprompt.com (128.commandprompt.com [207.173.200.128]) by svr1.postgresql.org (Postfix) with ESMTP id 7736A533AA for ; Wed, 23 Mar 2005 21:13:22 +0000 (GMT) Received: from [127.0.0.1] (clbb-248.saw.net [64.146.135.248]) (authenticated bits=0) by hosting.commandprompt.com (8.12.8/8.12.8) with ESMTP id j2NLAVkh022521; Wed, 23 Mar 2005 13:10:31 -0800 Message-ID: <4241DBF0.3010505@commandprompt.com> Date: Wed, 23 Mar 2005 13:13:20 -0800 From: "Joshua D. Drake" User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: "Joseph M. Day" Cc: pgsql-admin@postgresql.org Subject: Re: Backup References: <006d01c52fe8$b91868f0$6402a8c0@homepc> In-Reply-To: <006d01c52fe8$b91868f0$6402a8c0@homepc> Content-Type: multipart/mixed; boundary="------------020600040508030801060309" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.04 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/371 X-Sequence-Number: 16869 This is a multi-part message in MIME format. --------------020600040508030801060309 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit 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 --------------020600040508030801060309 Content-Type: text/x-vcard; charset=utf-8; name="jd.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="jd.vcf" begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;PO Box 215 ;Cascade Locks;OR;97014;US email;internet:jd@commandprompt.com 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 --------------020600040508030801060309--