Date: Mon, 22 Jul 2019 10:48:51 +0900
From: Michael Paquier <michael@paquier.xyz>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Jesper Pedersen <jesper.pedersen@redhat.com>,
	Laurenz Albe <laurenz.albe@cybertec.at>,
	Alvaro Herrera <alvherre@2ndquadrant.com>,
	PostgreSQL-development <pgsql-hackers@postgresql.org>
Subject: Re: pg_receivewal documentation
Message-ID: <20190722014851.GC1757@paquier.xyz>
References: <20190710142421.GA28387@alvherre.pgsql>
 <54779de5-f922-c0cf-629d-b582eded7265@redhat.com>
 <20190716050555.GA1439@paquier.xyz>
 <ebed4b9043b222d486ea3f0e44e7dcd242a80781.camel@cybertec.at>
 <65c3ecdf-8995-34cb-83c4-50068877e632@redhat.com>
 <20190717013835.GA2130@paquier.xyz>
 <CA+TgmoY-8im5GHnSf1zih8t66DOcy7CO+i_p01LbP6ck+Unhpg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="AbQceqfdZEv+FvjW"
Content-Disposition: inline
In-Reply-To: 
 <CA+TgmoY-8im5GHnSf1zih8t66DOcy7CO+i_p01LbP6ck+Unhpg@mail.gmail.com>
Precedence: bulk


--AbQceqfdZEv+FvjW
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, Jul 19, 2019 at 02:04:03PM -0400, Robert Haas wrote:
> You could just say something like:
>=20
> Since pg_receivewal does not apply WAL, you should not allow it to
> become a synchronous standby when synchronous_commit =3D remote_apply.
> If it does, it will appear to be a standby which never catches up,
> which may cause commits to block.  To avoid this, you should either
> configure an appropriate value for synchronous_standby_names, or
> specify an application_name for pg_receivewal that does not match it,
> or change the value of synchronous_commit to something other than
> remote_apply.
>=20
> I think that'd be a lot more useful than enumerating the total-failure
> scenarios.

+1.  Thanks for the suggestions!  Your wording looks good to me.
--
Michael

--AbQceqfdZEv+FvjW
Content-Type: application/pgp-signature; name="signature.asc"

-----BEGIN PGP SIGNATURE-----

iQIzBAABCgAdFiEEG72nH6vTowiyblFKnvQgOdbyQH0FAl01FgMACgkQnvQgOdby
QH2n6g/+IibnTlvCSQ2HOOoxdskaKbQa3pqZ4aizUZZuxidcvQt/DVPNiYQLOKOe
7r5YgeS510ZRsBps0uVcJ0OwSbtbL9lhq9qpnMdall1TtFupS8IadKV7u1GF2dOv
cMKJ/wYQyKmWiLcnJoXB480pNK/X1fxEnWImiV8jyP6dzeBpdLj3TUcti0QEE7SD
yAHv0LehGbBgv5y0bkbawv1Oc4HRVEibLWfFP970Mozged/P9BnSieBxQwrY2bo1
hA/JnhFEpPL1uCqroqprnnWjcliSl+T36kDp+jaLSRmZxu9tiOC8aGtTJv4pd1v/
0yI/GA7uGbEX2oac+GUNydfdZqmg35ldr7sCmUWlrBBrbAEF7Vki1xo3llYFa5LY
rCYIMbUghm67/a0L6cxKGDCtPFuUR4/uPf56aNlFmPJIvLKrsJ5ZwH5Wu/18bR1n
wnp8sjuKBqRmN7bVj/MfxuXfvNyTobOYEYvV5KzmhvFNKaDN62W/jFKsDPXAAJVj
3GtlFUjUEzpXGjYM+zN819bY90/R/1pzPUviQR0xu3MqdRqQXKkoTDoRWuLlwxOD
tJIctwEGkVGTl4jOWBx5Ec9hzwifP9z4S4NjJ6tdagbv4zx/xBaB/10xY13rK/t7
e4nnJowmZP2cHi/BnW/SDVtXUANif4iWGoot9ZBH07fA3SNZb7g=
=MEqA
-----END PGP SIGNATURE-----

--AbQceqfdZEv+FvjW--