Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Could you point me to a good book about setting up a PostgreSQL cluster? The goal is to set up an active-passive cluster spread across two different data centers to achieve high availability.

share|improve this question

migrated from stackoverflow.com Dec 17 '12 at 0:04

This question came from our site for professional and enthusiast programmers.

4  
What's wrong with the manual: postgresql.org/docs/current/static/high-availability.html –  a_horse_with_no_name Dec 16 '12 at 20:10
1  
Also check out repmgr - repmgr.org –  Craig Ringer Dec 16 '12 at 23:08

1 Answer 1

There are a few problems with any recommendations here. The basic issue is that you have a set of tradeoffs in all replication solutions that you won't find in a single source.

The simple approach is to start with the documentation and work on setting up the built-in replication. The manual is a good place to start there. If all you want is a copy of everything that's what you want. Pay close attention to the hardware and software points there and make sure the systems are essentially the same architecture and OS (i.e. both 64-bit, and both Linux). Ideally they should be the same OS version and PostgreSQL compiled with the same options (binary packages are good here).

However if that doesn't cut it, here are some book recommendations:

"PostgreSQL 9.0 High Performance" by Greg Smith and "The PostgreSQL 9 Admin Cookbook" by Simon Riggs and Hannu Krosing.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.