I'm lost when it comes to choose the failover technology for my postgresql database. The options I currently see are:
- PG Cluster
- Streaming Replication
- Warm Standby (log shipping?)
- Hot Standby
Is there a feature comparison site where I can see the differences between those strategies? Is one of the mentioned techniques already deprecated or not anylonger in development? Is there a statement which requirements are covered by the available failover techniques?
My primary requirement is to provide a protection against data loss in case of a server failure. I already have a nightly backup of the database, however, this would not save me from loosing intra-day data.