Date: Wed, 27 Feb 2019 14:38:58 +0100
From: Johannes Truschnigg <johannes@truschnigg.info>
To: John Scalia <jayknowsunix@gmail.com>
Cc: Achilleas Mantzios <achill@matrix.gatewaynet.com>,
	pgsql-admin@lists.postgresql.org
Subject: Re: Logical replication and wal segment retention
Message-ID: <20190227133857.dvtswpk47aekermm@vault.lan>
References: <695C083D-AFB5-431B-B022-ED442CE94794@gmail.com>
 <20190227125242.6ixy4jkzcuj55cdl@vault.lan>
 <59567e0a-78e4-ed1c-f5b1-033aafcfb68a@matrix.gatewaynet.com>
 <75D08FE7-36EC-4721-9382-DF8AF508644D@gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha512;
	protocol="application/pgp-signature"; boundary="sj3bddayvux6yqsp"
Content-Disposition: inline
In-Reply-To: <75D08FE7-36EC-4721-9382-DF8AF508644D@gmail.com>
User-Agent: NeoMutt/20170113 (1.7.2)
Precedence: bulk


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

On Wed, Feb 27, 2019 at 08:29:09AM -0500, John Scalia wrote:
> I thought as much. The basic problem, however, is that I never created the
> logical slots. The IIDR application did that all by itself, and after it
> terminated, it did not bother to remove the slots. So, my disk monitor th=
rew
> up when the WAL file system began to fill up. I was trying then to figure
> out why it did that.

I don't know the particular product that made you experience these troubles,
but it could be on purpose (if it relies on consuming the WAL continuously,
like a proper streaming replication slave/secondary would, and expectes to =
be
able to continue working where it left off before terminating) - or it could
be a rather dangerous usability hurdle that should, at the very least, be
clearly documented.


--=20
with best regards:
- Johannes Truschnigg ( johannes@truschnigg.info )

www:   https://johannes.truschnigg.info/
phone: +43 650 2 133337
xmpp:  johannes@truschnigg.info

Please do not bother me with HTML-email or attachments. Thank you.

--sj3bddayvux6yqsp
Content-Type: application/pgp-signature; name="signature.asc"

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

iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAlx2kvEACgkQ95W3jMsY
fLXBRA/7BmYwR1smuBosmuMLz16bWbDMFtMoMPzToYlAeGXCIgZde2HaWqtelHkx
qfHkX86W8ygRYfD1H5fnLSUZ5R67Ca3drOgeX4x3qJhGDaVjfVR91aVLKEcnYBf/
T9QeRsmHyv8D4A5k8AJMl5oeNebpF2J+qUk0gnt4aZ5l9Uhy+wV1zf+65on5JNFe
6A46wDUckciTBjsGfXE+men11a23Bpzemodp8BxB3QEMSeaazqMcnPwzucCJVQ5Q
crMCg+jsIPuPMK8VuaAUM2ZHOxnrkYbfYX+wpFt4TCnDv3QY8vfL80zQHVmpleQL
7nEnAkd3nUK6UCNDXUx+3/HgnzfXBylMHSvUDOLuhxn1CjhwqXJv0Bck2yCmhLE/
wXOqsyDPJTS6V2AzQ+vOBnay4S16MrkLzZIHV4HmAv9oyVZVnqMXDQXk8Fl1vGwO
tscCTkd6CElOHWOVBKdKz7wTAaDNSfqvzmP3A3pbwYqM6nqfJwe3MX91tybXPd/W
sXRhTG5OzQ4I7IniBRcM5D/J1fT47TauUtmgL911+phQHjg4bE8HMsrpFosG4F1f
p8AKtAmRhq8wNr6gbZ7AbhmSHsViJXCRbN2pBfGJzMUu6ANIuSaffSHiAMpAKquq
c0LGo9Bz6fLj202W++M9xti9Q7C+xF2PgzneuSuy+QV0Dt89eRM=
=sbcf
-----END PGP SIGNATURE-----

--sj3bddayvux6yqsp--