On 01/11/10 20:26, Thomas Kellerer wrote:
Jonathan Tripathy wrote on 01.11.2010 21:12:
9.0 has streaming replication and "Hot Standby"
http://www.postgresql.org/docs/current/static/hot-standby.html
http://www.postgresql.org/docs/current/static/warm-standby.html#STREAMING-REPLICATION
But does that not only allow "read-only" things to work on the standby?
But you didn't ask for read/write on the standby, only for a standby
that can take of the master once the master fails:
"must support INSERTS and UPDATES as well (once the master has failed)"
That's exactly what the hot standby does: As long as it is in standby
mode it's read-only.
Once the failover has happened the standby is the new master and will
allow read/write access.
Thomas
Ahh!! So in both those links above, once the master has failed, the
standby will support writes (As it not acts like the master)?
Thanks
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
