Received: from localhost (maia-2.hub.org [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5D1929FB1ED for ; Tue, 7 Aug 2007 13:35:55 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 43942-04 for ; Tue, 7 Aug 2007 13:35:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from tinlc.com (unknown [72.18.206.65]) by postgresql.org (Postfix) with ESMTP id 2AEF79FA649 for ; Tue, 7 Aug 2007 13:35:44 -0300 (ADT) Received: from localhost ([127.0.0.1]) by tinlc.com with smtp (Exim 4.60) (envelope-from ) id 1IIS2E-0005pN-Kl; Tue, 07 Aug 2007 11:35:54 -0500 From: "Greg Sabino Mullane" To: pgsql-admin@postgresql.org Subject: Re: PITR with rsync X-PGP-Key: 2529 DF6A B8F7 9407 E944 45B4 BC9B 9067 1496 4AC8 X-Request-PGP: http://www.biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 In-Reply-To: <6080.1186448021@sss.pgh.pa.us> Date: Tue, 7 Aug 2007 16:35:54 -0000 X-Mailer: JoyMail 2.01 Message-ID: <6741ad8e3e180ae26294a16502c8221b@biglumber.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200708/47 X-Sequence-Number: 26378 -----BEGIN PGP SIGNED MESSAGE----- Hash: RIPEMD160 Tom Lane wrote: >> 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. > If you are going over an ssh connection then scp seems like the > appropriate tool. Yeah, rsync would work, but it's just a useless > extra layer of software... In addition to the atomicity advantage, rsync allows compression of the data on the fly. While you can also pass the -C flag to scp, I've found that the high compressibility of WAL files means that rsync -z is noticeably faster than scp -C (not that I would use the latter due to the partial file issue). - -- Greg Sabino Mullane greg@turnstep.com End Point Corporation PGP Key: 0x14964AC8 200708071229 http://biglumber.com/x/web?pk=2529DF6AB8F79407E94445B4BC9B906714964AC8 -----BEGIN PGP SIGNATURE----- iD8DBQFGuJ6FvJuQZxSWSsgRA9xdAKDL4VZONTcmuXJl7Cz4bqiWXWVuZQCfRJso 2QIy8xDl88G4AnMFNrADVhM= =iuKm -----END PGP SIGNATURE-----