Warm standby server - Mailing list pgsql-admin

From Scott Whitney
Subject Warm standby server
Date
Msg-id 20080626151632.E5CF63E20E4@mail.int.journyx.com
Whole thread Raw
Responses Re: Warm standby server  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-admin
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.

It'll be a RedHat RHEL-4 box on pg 8.1x



pgsql-admin by date:

Previous
From: Vishal Arora
Date:
Subject: Re: Query
Next
From: Guillaume Lelarge
Date:
Subject: Re: plpgsql function seems to be leaking memory