Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 61E5A650F38 for ; Thu, 26 Jun 2008 15:50:46 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 42519-02-8 for ; Thu, 26 Jun 2008 15:50:29 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail128138.authsmtp.com (outmail128138.authsmtp.com [62.13.128.138]) by postgresql.org (Postfix) with ESMTP id 4011D650FCF for ; Thu, 26 Jun 2008 15:33:28 -0300 (ADT) Received: from mail-c187.authsmtp.com (mail-c187.authsmtp.com [62.13.128.33]) by punt2.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m5QIWxFR061732; Thu, 26 Jun 2008 19:32:59 +0100 (BST) Received: from [192.168.0.3] (85-211-229-155.dyn.gotadsl.co.uk [85.211.229.155]) (authenticated bits=0) by mail.authsmtp.com (8.14.2/8.14.2/Kp) with ESMTP id m5QIWoU4099735; Thu, 26 Jun 2008 19:32:50 +0100 (BST) Subject: Re: Warm standby server From: Simon Riggs To: Scott Whitney Cc: "'Montaseri'" , pgsql-admin@postgresql.org In-Reply-To: <20080626175743.4E1B33E216E@mail.int.journyx.com> References: <20080626175743.4E1B33E216E@mail.int.journyx.com> Content-Type: text/plain Date: Thu, 26 Jun 2008 19:37:30 +0100 Message-Id: <1214505450.3845.239.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 4878235a-43ae-11dd-8155-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadRtFagNbZ0xf HGQLW1xEUVR7WmF/ bgsfZQBDYEtPQQdo WVZIR1dNFgBqBAMB SEMbM2AVKGBCeHd5 YkVnEHheWwp+fUF1 QE1RRHACZjY1dWEe BBRFfwJRdR5Kfh5E YlUrV3QKMjRJBA9q VzwaExUQGwAXFy1P R0kWMVsUTUwaViUx XQ4PB11z X-Authentic-SMTP: 61633235383639.squirrel.dmpriest.net.uk:1078/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-Archive-Number: 200806/228 X-Sequence-Number: 29566 On Thu, 2008-06-26 at 13:01 -0500, Scott Whitney wrote: > A 2nd question: Is it possible to have 2 standby servers with a single > master duplicating to standby1 (at my coloc), and standby2 (at my office)? > Assume no auto-failover. Yes, that works too. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support