Re: Warm standby server

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Scott Whitney <swhitney(at)journyx(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Warm standby server
Date: 2008-06-26 16:06:52
Message-ID: 1214496412.3845.202.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Domingo Alvarez Duarte 2008-06-26 17:04:54 Extended security/restriction to any role with login access
Previous Message Guillaume Lelarge 2008-06-26 15:48:51 Re: plpgsql function seems to be leaking memory