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.

  • What features do you need? Or, an even better way of expressing this: What requirements do you have? While streaming replication is now very easy to setup out of the box and may now be perceived by some as the de-facto standard way to setup a replica, it is -- as you say -- not the only way to do it and one of the others methods may be a better fit for you. As it stands, your question runs the risk of being closed as "too broad" or "unclear". – Colin 't Hart Jun 2 '14 at 11:22
  • I've added my primary requirement. Another non-technical requirement is to be able to choose among different failover options. – paweloque Jun 2 '14 at 11:30
  • 1
    In addition to your nightly backup, you only need the WAL to recover from an "intra-day" server failure. Both should be replicated off-server or off-site as you desire. You only need one of the more complex failover options to provide for a shorter downtime. – Colin 't Hart Jun 2 '14 at 11:49
  • 1
  • @Colin'tHart do you know a tutorial or documentation which describes how to setup WAL and how to recover data from a WAL? – paweloque Jun 2 '14 at 20:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.