Re:PostgreSQL 9.0 Final Release Available Now
by epi0Bauqu on Monday September 20, 2010 @10:37AM
(#1708951)
Why use hot-standby over streaming replication or visa-versa?
[ Parent
| on HN ]
Re:PostgreSQL 9.0 Final Release Available Now
by gxti on Monday September 20, 2010 @11:06AM
(#1709072)
It's a free upgrade from warm standby, whereas SR requires a little more configuration. A good SR cluster also requires that log archiving (warm/hot standby) be set up in case the stream gets behind, otherwise you're at the mercy of whatever happens to be in the master's xlog.
Re:PostgreSQL 9.0 Final Release Available Now
by crad on Monday September 20, 2010 @11:19AM
(#1709124)
Hot-Standby: Ability to query against what used to be Warm-Standby boxes which were for disaster recovery only.
Streaming Replication: sending log data over sockets instead of relying on shell commands to send logfiles over.
They work together to make for happy master-slave replication.
It's worth noting this is database server level. Hot-standby copies 100% of a PostgreSQL instance. If you want to replicate individual databases on a server or individual tables in a database, Longdiste, Bucardo or Slony are still the way to go.