Pgpool-II's Clustering Modes
Pgpool-II has been released for more than 15 years. When the version 1.0 was released, Pgpool-II had only replication mode. With the increase of new features (e.g. automatic failover, support for logical replication, etc.), the parameters for configuring cluster mode have increased. Clustering mode Pgpool-II has six clustering modes available: Streaming replication mode Native replication mode Snapshot isolation mode (Since Pgpool-II 4.2) Logical replication mode Slony mode Raw mode It is important to specify the correct clustering mode to make Pgpool-II work as expected, because the clustering mode is used to determine how the data is replicated. Since Pgpool-II 4.2, the multiple parameters for configuring cluster mode have been merged into a single parameter backend_clustering_mode . clustering mode Pgpool-II 4.1 or previous Pgpool-II 4.2 or later master_slave_mode master_slave_sub_mode replication_mode backend_clustering_mode Streaming repl