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 75245534AE for ; Wed, 23 Mar 2005 22:37:59 +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 54106-06 for ; Wed, 23 Mar 2005 22:37:55 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 8E03252A2E for ; Wed, 23 Mar 2005 22:37:54 +0000 (GMT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j2NMbtF7015120; Wed, 23 Mar 2005 17:37:55 -0500 (EST) To: "Joseph M. Day" Cc: pgsql-admin@postgresql.org Subject: Re: Backup In-reply-to: <006d01c52fe8$b91868f0$6402a8c0@homepc> References: <006d01c52fe8$b91868f0$6402a8c0@homepc> Comments: In-reply-to "Joseph M. Day" message dated "Wed, 23 Mar 2005 14:41:35 -0600" Date: Wed, 23 Mar 2005 17:37:55 -0500 Message-ID: <15119.1111617475@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.007 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200503/376 X-Sequence-Number: 16874 "Joseph M. Day" writes: > 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. The only built-in mechanism for incremental backups at the moment is archiving WAL logs via PITR. See http://www.postgresql.org/docs/8.0/static/backup-online.html > To keep the same functionality, I will need a full backup once a week, > and a differential once a day. You might consider rsync'ing the database, though I'm not sure what sort of performance that will give. regards, tom lane