Skip to content

Instantly share code, notes, and snippets.

Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save ghostbuster91/78c41f1b2e77fb0c7a0f22045fb51917 to your computer and use it in GitHub Desktop.
Save ghostbuster91/78c41f1b2e77fb0c7a0f22045fb51917 to your computer and use it in GitHub Desktop.
postgers_synchronous_replication_summary
+--------------+----------------+-----------------------------------------------------+
| | local | standbys |
+--------------+----------------+-------------------+----------------+----------------+
| | durable commit | query consistency | durable commit | durable commit |
| | | | after OS crash | after PG crash |
+--------------+----------------+-------------------+----------------+----------------+
| remote_apply | X | X | X | X |
+--------------+----------------+-------------------+----------------+----------------+
| on | X | | X | X |
+--------------+----------------+-------------------+----------------+----------------+
| remote_write | X | | | X |
+--------------+----------------+-------------------+----------------+----------------+
| local | X | | | |
+--------------+----------------+-------------------+----------------+----------------+
| off | | | | |
+--------------+----------------+-------------------+----------------+----------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment