Before performing the setup of the database multiplexing mode, ensure that the prerequisite streaming replication feature has been set up correctly.
Perform the following procedure:
On the primary server, ensure that single-row searches can be performed using the pg_stat_replication statistics view.
An example output of the psql command is shown below.
Example)
postgres=# select * from pg_stat_replication; -[ RECORD 1 ]----+------------------------------ pid | 16706 usesysid | 10 usename | symfo application_name | standby1 client_addr | 192.0.2.210 client_hostname | client_port | 26500 backend_start | 2014-04-25 14:21:30.097644+09 state | streaming sent_location | 0/3003C30 write_location | 0/3003C30 flush_location | 0/3003C30 replay_location | 0/3003C30 sync_priority | 1 sync_state | sync
Confirm the search results of step 1.
Ensure that the connection established with the intended standby server is in synchronous mode.
Item | Required value |
|---|---|
application_name | Value specified for synchronous_standby_names parameter in the postgresql.conf file of the primary server. |
client_addr | IP address of the standby server. |
state | "streaming". |
sync_state | "sync". |
See
Refer to "The Statistics Collector" in "Server Administration" in the PostgreSQL Documentation for information on the pg_stat_replication statistics view.
Note that the pg_stat_replication statistics view may change in the future.
