O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Replication best practices

Some general best practices for running replication systems are described in this chapter.

How to do it...

  • Use similar hardware and OS on all systems: Replication allows nodes to switch roles. If we switchover or failover to different hardware, we may get performance issues and it will be hard to maintain a smoothly running application.
  • Configure all systems identically, as far as possible: Use the same mount points, same directory names, same users; keep everything possible the same. Don't be tempted to make one system more important than the others in some way. It's just a single point of failure and gets confusing.
  • Give systems good names to reduce confusion: Never, ever call one of your systems "Master" and the other ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required