Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id B49F3650EFB for ; Thu, 26 Jun 2008 13:02:52 -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 57647-04 for ; Thu, 26 Jun 2008 13:02:45 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outmail136054.authsmtp.net (outmail136054.authsmtp.net [62.13.136.54]) by postgresql.org (Postfix) with ESMTP id 95281650EC5 for ; Thu, 26 Jun 2008 13:02:44 -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 m5QG2LhH022805; Thu, 26 Jun 2008 17:02:21 +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 m5QG2DP0019735; Thu, 26 Jun 2008 17:02:13 +0100 (BST) Subject: Re: Warm standby server From: Simon Riggs To: Scott Whitney Cc: pgsql-admin@postgresql.org In-Reply-To: <20080626151632.E5CF63E20E4@mail.int.journyx.com> References: <20080626151632.E5CF63E20E4@mail.int.journyx.com> Content-Type: text/plain Date: Thu, 26 Jun 2008 17:06:52 +0100 Message-Id: <1214496412.3845.202.camel@ebony.site> Mime-Version: 1.0 X-Mailer: Evolution 2.12.0 Content-Transfer-Encoding: 7bit X-Server-Quench: 3e112898-4399-11dd-8155-001185d377ca X-AuthRoute: OCdxZQATClZOTQEd DAteCiNZVAwpPBRK HVkIKg5MJUcNSQVJ NksadBtFagNbZ0xf HGQLW1xEUVp7WWF/ ag4fZQBDYEtPQQdo WVZIR1dNFgBqBAMB SEMbM25wA2VGeH95 YkVnEHFbWU00dhN8 Q0xcHGUbYWRpYX0e URQMagtVdQZXfh9E a1h6AHAKZjZWKBg1 TUcAFhwUHBNqYBtc WARFNk4bR0oBD3Yn SgocEC9H 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/221 X-Sequence-Number: 29559 On Thu, 2008-06-26 at 10:19 -0500, Scott Whitney wrote: > I've got 3 different database servers (db01, db02 and db03). > > I would like to have a WAL standby server that replays logs for all 3 in > case one goes down, so I can promote that particular server. > > Can I do this by installing 3 separate postmasters on this machine? > Obviously, if 2 went down at the same time, I'd have to do some magic to > bring up another machine, but I'm not sure that's a concern. Yes, that will work. -- Simon Riggs www.2ndQuadrant.com PostgreSQL Training, Services and Support