Re: Warm standby server - Mailing list pgsql-admin

From Simon Riggs
Subject Re: Warm standby server
Date
Msg-id 1214496412.3845.202.camel@ebony.site
Whole thread Raw
In response to Warm standby server  ("Scott Whitney" <swhitney@journyx.com>)
Responses Re: Warm standby server
List pgsql-admin
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


pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: plpgsql function seems to be leaking memory
Next
From: "Domingo Alvarez Duarte"
Date:
Subject: Extended security/restriction to any role with login access