Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kaGWb-0004K4-J7 for pgsql-admin@arkaria.postgresql.org; Wed, 04 Nov 2020 11:00:21 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kaGWa-0005Lp-Ez for pgsql-admin@arkaria.postgresql.org; Wed, 04 Nov 2020 11:00:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kaGWa-0005Li-3C for pgsql-admin@lists.postgresql.org; Wed, 04 Nov 2020 11:00:20 +0000 Received: from truschnigg.info ([89.163.150.210]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1kaGWV-0001QW-Rz for pgsql-admin@lists.postgresql.org; Wed, 04 Nov 2020 11:00:19 +0000 Received: from vault.lan (84-112-34-152.cable.dynamic.surfer.at [84.112.34.152]) by truschnigg.info (Postfix) with ESMTPSA id C7174200EB; Wed, 4 Nov 2020 11:00:13 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=truschnigg.info; s=mail; t=1604487614; bh=bsPi/iIvaRMm1nAEGmZeJpwrdSMQUbYo1fTq4Rq7e+s=; h=Date:From:To:Cc:Subject:References:In-Reply-To:From; b=UAPIQ3uWIwZ/yH5bp9ntvMC2IGZMnXkwAUGY9lv3s12xsojAcWeeUpRGH9f8oMbPm Mn1FcYMqgs+btc8/TlVni0xfPzuDD3a0BkTi4uVi+ocfyb6j6afqbjALrDSxRWFCKk 1PxG944E2nr5rHB4nsLicm6xHoGb3IGs02P4IDKI= Date: Wed, 4 Nov 2020 12:00:07 +0100 From: Johannes Truschnigg To: Yambu Cc: pgsql-admin@lists.postgresql.org Subject: Re: Logical replication alternative Message-ID: <20201104110006.GB15818@vault.lan> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="E39vaYmALEf/7YXx" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.10.1 (2018-07-13) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --E39vaYmALEf/7YXx Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi Yambu, On Wed, Nov 04, 2020 at 12:55:02PM +0200, Yambu wrote: > Hi >=20 > May i know what is the alternative to logical replication if i want to > replicate a few tables on postgres v10? You may want to look into SkyTools[0], which provide the infrastructure to enable trigger-based replication approaches via PgQ/Londiste. [0]: https://wiki.postgresql.org/wiki/SkyTools --=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. --E39vaYmALEf/7YXx Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAl+iibMACgkQ95W3jMsY fLWsCRAAgmCwK1NZU6rTPOh/jyhY0r18xOKo2h/00bM9gXBTYmX7U9l/Qj4WAZoc +M/sKqKD12vAOtiXz3Z/0D44LGdAIOE5ySDLPGHQ+SoLvknEwu4hW2bkQuKcONLE NnCbrx1F98yn31rqkm/eR3YRsKO5Fy9bUUi2hdubRygxs0+YJJFnvZwzs4jXmnH2 oWpwuJhEadPyx2Bl74rBP0pJ2c6hco03hna3t2EzJ/lZiV1hTPxksIGwVe4Rh/vW 6r0Tgrc0YX6KRYC7SpuXpZwRn4277SRiwoybCXjVKZNeFhwJeozkJPxZyAOl3KPp dYAMH1knPyW9K20rVB1wgZDGLfipFPdSYDoc8bzGI4tROQBNrHJjX+nf4QLwF5uR QCTTvd6MPlkoSI7FUddhF1aHt+9PjhLkSqzU9abchGf7P2OFOAggVMUjntCB+xyJ fD5sc9Jc91RgktQ7wJ4bNPnPJYbYERBqJ2drU28tbvbH24CJqo1ujsP3WeJalW9M A7FethW2sWt7tKyqHYoVTFzA2GEon03KONN/FYsdZUy5gNGBNCPDwpu1ZuARPtGz DDvTh2lktEQBXiDxyJSUUs90LjMSkEwQ/2HPfN6XEdvPK1Wfis072KzFwKv6vP0d XYCIHfjjSvJpUZ69uspIqD7+UseATS5yMNmcdsFz9zPKNMlyA1I= =N3S+ -----END PGP SIGNATURE----- --E39vaYmALEf/7YXx--