Received: from localhost (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id BD21364FEF9 for ; Fri, 19 Dec 2008 13:12:14 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 09535-08 for ; Fri, 19 Dec 2008 13:12:11 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136055.authsmtp.co.uk (outmail136055.authsmtp.co.uk [62.13.136.55]) by mail.postgresql.org (Postfix) with ESMTP id EADBE64FE65 for ; Fri, 19 Dec 2008 13:12:05 -0400 (AST) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt9.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id mBJHBwjf037423; Fri, 19 Dec 2008 17:11:58 GMT Received: from [192.168.0.3] (85-211-226-82.dyn.gotadsl.co.uk [85.211.226.82]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id mBJHBuJq085124; Fri, 19 Dec 2008 17:11:56 GMT Subject: Re: Warm Standby - log shipping From: Simon Riggs To: jd@commandprompt.com Cc: Mark Steben , "'Kevin Grittner'" , pgsql-admin@postgresql.org In-Reply-To: <1229705491.9383.15.camel@jd-laptop.pragmaticzealot.org> References: <494A7819.EE98.0025.0@wicourts.gov> <1229705491.9383.15.camel@jd-laptop.pragmaticzealot.org> Content-Type: text/plain Date: Fri, 19 Dec 2008 17:12:05 +0000 Message-Id: <1229706725.4793.556.camel@ebony.2ndQuadrant> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 2410a215-cdf0-11dd-8155-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksachtFaQxbaVxS HGQLW1xEUVp7WGJ/ bg0fZQBDYEtPQQdo VlZBQE1QEQdtHhxP W2xkKms3DURGcHtx Z0IsX3NcWgp4cUd9 E0xVEHBVMTFgdWEe BBRFfwJRdR5Kfh5E YlUrV3QKMjRJBC9q VzwaExUQGwAXFy1P R0k2MVsUTUwaVnt0 QxcNVS4vHFUdRiM8 RyAn X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1378/Kp X-Report-SPAM: If SPAM / abuse - report it at: http://www.authsmtp.com/abuse X-Virus-Status: No virus detected - but ensure you scan with your own anti-virus system. X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200812/163 X-Sequence-Number: 30996 On Fri, 2008-12-19 at 08:51 -0800, Joshua D. Drake wrote: > On Fri, 2008-12-19 at 09:14 -0500, Mark Steben wrote: > > What I'm hearing is that I have to perform a base backup on my master in > > Mass. after recovery completes, send that over a secure network > > To Virginia, and lay it down there. Simple enough but the time to travel > > Over the network becomes an issue - 12 - 13 hours at best. > > If we have to do this then we will. I just want to make sure I'm > > understanding your advice. > > Yes. Yes, but use rsync, so you don't need to wait for 13 hours. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support