From: Simon Riggs <simon@2ndquadrant.com>
To: Scott Whitney <swhitney@journyx.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Warm standby server
Date: Thu, 26 Jun 2008 17:06:52 +0100
Message-ID: <1214496412.3845.202.camel@ebony.site> (raw)
In-Reply-To: <20080626151632.E5CF63E20E4@mail.int.journyx.com>
References: <20080626151632.E5CF63E20E4@mail.int.journyx.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: simon@2ndquadrant.com, swhitney@journyx.com
Subject: Re: Warm standby server
In-Reply-To: <1214496412.3845.202.camel@ebony.site>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox