Hacker News new | past | comments | ask | show | jobs | submit login

Why use hot-standby over streaming replication or visa-versa?



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.


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.




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: