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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin