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

Managing Hot Standby

Hot Standby is the name for the PostgreSQL feature that allows us to connect to a Standby database and execute read-only queries. Most importantly, Hot Standby allows us to run queries while the Standby is being continuously updated through either file-based or streaming replication.

Hot Standby allows you to offload larger queries or parts of your read-only workload onto the Standby nodes. Should you need to failover to the Standby node, your queries will keep executing during the failover process to avoid any interruption of service.

There are some complexities that need to be understood to manage Hot Standby successfully, as in some cases user queries can conflict with the continuous application of changes from the Master. ...

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