aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorTom Lane <tgl@sss.pgh.pa.us>2020-05-14 18:44:18 -0400
committerTom Lane <tgl@sss.pgh.pa.us>2020-05-14 18:44:18 -0400
commit2e619f86a96c32a710a09a4ff555952746813ba8 (patch)
treeefb32eb5733c6f61cb45fdc5152b1063fb41b563
parent3d14c174cbbb6f83d8ac63fa7d0e1f42e0ae8d30 (diff)
downloadpostgresql-2e619f86a96c32a710a09a4ff555952746813ba8.tar.gz
postgresql-2e619f86a96c32a710a09a4ff555952746813ba8.zip
Doc: hack on table 26.1 till it fits in PDF format.
I abbreviated the heck out of the column headings, and made a few small wording changes, to get it to build warning-free. I can't say that the result is pretty, but it's probably better than removing this table entirely. As of this commit, we have zero "exceed the available area" warnings in a US-letter PDF build, and one such warning (about an 863-millipoint overrun) in an A4 build. I expect to get rid of that one by renaming wait events, so I'm not doing anything about it at the formatting level. Discussion: https://postgr.es/m/6916.1589146280@sss.pgh.pa.us
-rw-r--r--doc/src/sgml/high-availability.sgml56
1 files changed, 30 insertions, 26 deletions
diff --git a/doc/src/sgml/high-availability.sgml b/doc/src/sgml/high-availability.sgml
index 8862f84412e..44cc5d2116d 100644
--- a/doc/src/sgml/high-availability.sgml
+++ b/doc/src/sgml/high-availability.sgml
@@ -198,11 +198,11 @@ protocol to make nodes agree on a serializable transactional order.
</varlistentry>
<varlistentry>
- <term>Statement-Based Replication Middleware</term>
+ <term>SQL-Based Replication Middleware</term>
<listitem>
<para>
- With statement-based replication middleware, a program intercepts
+ With SQL-based replication middleware, a program intercepts
every SQL query and sends it to one or all servers. Each server
operates independently. Read-write queries must be sent to all servers,
so that every server receives any changes. But read-only queries can be
@@ -279,19 +279,6 @@ protocol to make nodes agree on a serializable transactional order.
</listitem>
</varlistentry>
- <varlistentry>
- <term>Commercial Solutions</term>
- <listitem>
-
- <para>
- Because <productname>PostgreSQL</productname> is open source and easily
- extended, a number of companies have taken <productname>PostgreSQL</productname>
- and created commercial closed-source solutions with unique
- failover, replication, and load balancing capabilities.
- </para>
- </listitem>
- </varlistentry>
-
</variablelist>
<para>
@@ -302,28 +289,37 @@ protocol to make nodes agree on a serializable transactional order.
<table id="high-availability-matrix">
<title>High Availability, Load Balancing, and Replication Feature Matrix</title>
<tgroup cols="9">
+ <colspec colname="col1" colwidth="1.1*"/>
+ <colspec colname="col2" colwidth="1*"/>
+ <colspec colname="col3" colwidth="1*"/>
+ <colspec colname="col4" colwidth="1*"/>
+ <colspec colname="col5" colwidth="1*"/>
+ <colspec colname="col6" colwidth="1*"/>
+ <colspec colname="col7" colwidth="1*"/>
+ <colspec colname="col8" colwidth="1*"/>
+ <colspec colname="col9" colwidth="1*"/>
<thead>
<row>
<entry>Feature</entry>
- <entry>Shared Disk Failover</entry>
- <entry>File System Replication</entry>
+ <entry>Shared Disk</entry>
+ <entry>File System Repl.</entry>
<entry>Write-Ahead Log Shipping</entry>
- <entry>Logical Replication</entry>
- <entry>Trigger-Based Master-Standby Replication</entry>
- <entry>Statement-Based Replication Middleware</entry>
- <entry>Asynchronous Multimaster Replication</entry>
- <entry>Synchronous Multimaster Replication</entry>
+ <entry>Logical Repl.</entry>
+ <entry>Trigger-Based Repl.</entry>
+ <entry>SQL Repl. Middle-ware</entry>
+ <entry>Async. MM Repl.</entry>
+ <entry>Sync. MM Repl.</entry>
</row>
</thead>
<tbody>
<row>
- <entry>Most common implementations</entry>
+ <entry>Popular examples</entry>
<entry align="center">NAS</entry>
<entry align="center">DRBD</entry>
- <entry align="center">built-in streaming replication</entry>
- <entry align="center">built-in logical replication, pglogical</entry>
+ <entry align="center">built-in streaming repl.</entry>
+ <entry align="center">built-in logical repl., pglogical</entry>
<entry align="center">Londiste, Slony</entry>
<entry align="center">pgpool-II</entry>
<entry align="center">Bucardo</entry>
@@ -331,7 +327,7 @@ protocol to make nodes agree on a serializable transactional order.
</row>
<row>
- <entry>Communication method</entry>
+ <entry>Comm. method</entry>
<entry align="center">shared disk</entry>
<entry align="center">disk blocks</entry>
<entry align="center">WAL</entry>
@@ -485,6 +481,14 @@ protocol to make nodes agree on a serializable transactional order.
</variablelist>
+ <para>
+ It should also be noted that because <productname>PostgreSQL</productname>
+ is open source and easily extended, a number of companies have
+ taken <productname>PostgreSQL</productname> and created commercial
+ closed-source solutions with unique failover, replication, and load
+ balancing capabilities. These are not discussed here.
+ </para>
+
</sect1>