Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group