Received: from localhost (maia-5.hub.org [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 807C79FB3E8 for ; Mon, 6 Aug 2007 21:11:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 07965-08 for ; Mon, 6 Aug 2007 21:11:12 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from epo-int1.asu.edu (epo-int1.asu.edu [129.219.187.20]) by postgresql.org (Postfix) with ESMTP id 417A49FB3A3 for ; Mon, 6 Aug 2007 21:11:17 -0300 (ADT) Received: from teancum.pp.asu.edu (teancum.pp.asu.edu [129.219.198.16]) by epo-int1.asu.edu (Switch-3.1.8/Switch-3.1.7/asu-postoffice-prod) with ESMTP id l770BEDx008072 for ; Mon, 6 Aug 2007 17:11:14 -0700 Received: by teancum.pp.asu.edu (Postfix, from userid 1000) id A1CA91066; Mon, 6 Aug 2007 17:11:14 -0700 (MST) Date: Mon, 6 Aug 2007 17:11:14 -0700 From: David Bear To: pgsql-admin@postgresql.org Subject: PITR with rsync Message-ID: <20070807001114.GD19294@asu.edu> Reply-To: David.Bear@asu.edu Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/36 X-Sequence-Number: 26367 I've been looking at the pages on PITR and am wondering if anyone has tried using rsync to accomplish this. I'm still uncomfortable with using the file system style backup method in PITR and am very interested in ' more information ' on how others may be doing backups. Specifically, I assume that PITR methods would also be accompanied with some combination of pg-dump. I am curious about how frequently a pg-dump would be done if a PITR method was also used (every 24 hours, every 7 days, not at all ) ?? Also, looking at the archive_command argument in postgresql.conf. Has anyone use rsync there? -- David Bear phone: 602-496-0424 fax: 602-496-0955 College of Public Programs/ASU University Center Rm 622 411 N Central Phoenix, AZ 85007-0685 "Beware the IP portfolio, everyone will be suspect of trespassing"