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