Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id E2E7A9FB3E8 for ; Mon, 6 Aug 2007 21:46:44 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 10953-07 for ; Mon, 6 Aug 2007 21:46:33 -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 ADEF09FB1F1 for ; Mon, 6 Aug 2007 21:46:10 -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 l770k8R2022846; Mon, 6 Aug 2007 17:46:08 -0700 Received: by teancum.pp.asu.edu (Postfix, from userid 1000) id 83E9A1066; Mon, 6 Aug 2007 17:46:08 -0700 (MST) Date: Mon, 6 Aug 2007 17:46:08 -0700 From: David Bear To: Tom Lane Cc: pgsql-admin@postgresql.org Subject: Re: PITR with rsync Message-ID: <20070807004608.GE19294@asu.edu> Reply-To: David.Bear@asu.edu References: <20070807001114.GD19294@asu.edu> <5382.1186446433@sss.pgh.pa.us> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5382.1186446433@sss.pgh.pa.us> User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/38 X-Sequence-Number: 26369 On Mon, Aug 06, 2007 at 08:27:13PM -0400, Tom Lane wrote: > David Bear writes: > > 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. > > You assume wrong. Replaying WAL demands starting from a physical not > logical dump, because page and tuple numbers and so forth have to be the > same as in the master. A pg_dump backup will simply not work. > > > 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 ) ?? > > I'd personally be inclined to take a pg_dump every now and then just to > have an independent backup method. Especially if I wasn't comfortable > with PITR ;-). How often depends on how much bandwidth you can spare > for backup purposes. okay, thanks. the pg-dump is not an augementation, but a completely separate backup method. > > > Also, looking at the archive_command argument in postgresql.conf. Has > > anyone use rsync there? > > I suppose you could, but what's the point? Copying a single file that > doesn't currently exist on the destination plays to none of rsync's > strengths. well, I was using rysnc so I could copy to a different computer over ssh, not using the rsync protocol to catch diffs. I don't have a remote file system mounted so I can do just a cp. Am I still thinking wrong here? > > regards, tom lane -- 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"