Postgres 9.0 Hot Standby + Fail Over

From: Bryan Murphy <bmurphy1976(at)gmail(dot)com>
To: PGSQL Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Postgres 9.0 Hot Standby + Fail Over
Date: 2010-05-05 02:53:47
Message-ID: u2y7fd310d11005041953q4708b3e7o503878d3ce6dba5b@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

We have a production database that contains data which is easily
recreated at runtime. I'm considering upgrading this to 9.0 beta1 to
get some experience with the new hot standby system on a server that
is under medium to heavy load.

Obviously, being a production database, it's inconvenient if this
fails (but not catastrophic for us, which is why I want to try it).

If partial updates are enabled and the master fails, I'd still like to
fail over to one of the slaves. If the last log file was not shipped,
but part of the queries for it were replicated, what happens?

What happens if I have two slave servers (A and B) and I want to fail
over to slave A and have it start shipping log files to slave B but B
has more queries applied to it than A? I assume in this case I would
instead want to fail over to B and ship to A. How would I know which
server to fail over to?

Thanks,
Bryan

Browse pgsql-general by date

  From Date Subject
Next Message AI Rumman 2010-05-05 05:01:29 How can I be confirm that data is encrypted over the network using SSL
Previous Message Tom Lane 2010-05-05 00:25:50 Re: Function not RAISE NOTICE if a parameter is NULL