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 1mgQfs-0002IQ-KN for pgsql-admin@arkaria.postgresql.org; Fri, 29 Oct 2021 12:07:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mgQfM-0006J7-42 for pgsql-admin@arkaria.postgresql.org; Fri, 29 Oct 2021 12:07:24 +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 1mgQfL-0006HO-Pl for pgsql-admin@lists.postgresql.org; Fri, 29 Oct 2021 12:07:23 +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 1mgQfI-0002CM-N4 for pgsql-admin@lists.postgresql.org; Fri, 29 Oct 2021 12:07:23 +0000 Received: from vault.lan (84-112-34-152.cable.dynamic.surfer.at [84.112.34.152]) by truschnigg.info (Postfix) with ESMTPSA id B0B5B20041; Fri, 29 Oct 2021 12:07:18 +0000 (UTC) DKIM-Signature: v=1; a=rsa-sha256; c=simple/simple; d=truschnigg.info; s=mail; t=1635509238; bh=cxWyCWjW0+335cKj4nf3ZmY9ZuYNAaz8mH2RwFj5SVY=; h=Date:From:To:Cc:Subject:References:In-Reply-To:From; b=vjtUlzIrqcwno/zn9GhDM1fk5Lr0jiDQ2CBJHGzR+VqNQHlZTFZ0artHhI19mgSOD Ut9fkDCOsvZBbBCtvqc9iFICDGEhNOOmEm7Iq84FsDBUFeBYCEJja/2Er2BryCs5Tc xQ3PQmMQbhd2CFbS0E1Ew1UjV5gufOcujshpg02Y= Date: Fri, 29 Oct 2021 14:07:16 +0200 From: Johannes Truschnigg To: MARIANE K Cc: Pgsql-admin Subject: Re: Question about postgres replication construction Message-ID: References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="4lZuHiswISBA4vFC" Content-Disposition: inline In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --4lZuHiswISBA4vFC Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Hi Marian, On Fri, Oct 29, 2021 at 01:49:30PM +0200, MARIANE K wrote: > [...] >=20 > By the way I've found my error. I forgot to change the archive_command on > node 2. After changing that it worked like a charm. > However i'm interested if anyone has other (better) ideas in how to tackle > this. I think it's going to be very hard to try suggesting something, since you never told us about the actual goal of your implementation. What do actually hope to achieve with the setup you described earlier in this thread? What properties and qualities should your system exhibit, and which shortcomings does it need and try to avoid? If you elaborate on that, someone might be able to come up with improvement= s, or at least comments on, your current architecture and implementation. --=20 with best regards: - Johannes Truschnigg ( johannes@truschnigg.info ) www: https://johannes.truschnigg.info/ phone: +436502133337 xmpp: johannes@truschnigg.info --4lZuHiswISBA4vFC Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEEGu9IhkI+7/aKLUWF95W3jMsYfLUFAmF74/EACgkQ95W3jMsY fLVMFw//ZDtzliNM9JijwnN6L+kBX5seBqPOXhfZGDFy0ptXL2ahSpFQYTTILBYj x/hOjw9eMBU9GRrjZg7y7Wk6K0kLe05zjyHQ8aTmi+4kSelraaIHSfo/+MkHwjOL Dh4DlSXfMbKGDzuRNak1XCJYnNmGYDPePPuwfiCyV6nQrJG8G6Hhl9iVGTzHZB/r mAmWMo51remQzA4kh7SneIFLbNzJVFvlhcxLJXnJoUP98OJbNwAdjkeieScwSnhp KvxduXz74OhhdADz37g81Oep00w3APnSRRLS0Cjy+ELbMu61G2A6BKWjKCs0wR2L vQhyN4RLOEda+95LB3XHg8h7Lz0M3fRyBbD2GQhB2Qma2C0Htd5qIbxRo25Kx78I /m6w2/MJAkEKCsb57XGtX4Opi9UpE5G2cAkVdMDXG9Hb4unTksyT/6C1zLsxsLoO 2lwzOCkLtwnPXQB7GLbUZ6+M3mxclCUZ1Vg8ORmw+K8Db5gulQ3cdZ1TPFEumjat wPBjM1RXKEHAJ1HzZ866zptcUbVJY9ZyhSckk4SGQE3PbYS9IKVGpdsDYKarLLFz aomPDngiofhzQnhN5FJYJ9D9JL683+OV1zqZ3GW4vr4jTKofbflSP79MylWFR1CF +tsbH9XRuilPTnmTvI3HtYD2aH/rn879G78/zumEAZ91lDWQdqQ= =zq2E -----END PGP SIGNATURE----- --4lZuHiswISBA4vFC--