PostgreSQL/Streaming_Replication

Last-modified: 2011-11-12 (土) 22:53:59

Streaming Replication

system diagram 

                 +-------------+
                | Application |
                +-------------+
                       |
                       V
                  +--------+
                  | pgpool |
                  +--------+
                       |
       +---------------+--------------+
       |                              |
       V                              V
 +-----------+    wal trans      +----------+
 |  pgsql01  |  <------------->  | pgsql02 |
 +-----------+                   +----------+
       |                              |
       |         +-----------+        |
       +-------->|  archive  |<-------+
                 +-----------+