Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rZUSZ-004eid-2F for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Feb 2024 11:26:52 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.94.2) (envelope-from ) id 1rZUSX-009CBG-Ad for pgsql-hackers@arkaria.postgresql.org; Mon, 12 Feb 2024 11:26:49 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rZUSV-009C78-D2 for pgsql-hackers@lists.postgresql.org; Mon, 12 Feb 2024 11:26:48 +0000 Received: from out2-smtp.messagingengine.com ([66.111.4.26]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rZUSS-006M52-9s for pgsql-hackers@postgresql.org; Mon, 12 Feb 2024 11:26:45 +0000 Received: from compute6.internal (compute6.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id D1C1B5C0058; Mon, 12 Feb 2024 06:26:42 -0500 (EST) Received: from mailfrontend1 ([10.202.2.162]) by compute6.internal (MEProxy); Mon, 12 Feb 2024 06:26:42 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-transfer-encoding :content-type:content-type:date:date:feedback-id:feedback-id :from:from:in-reply-to:in-reply-to:message-id:mime-version :reply-to:subject:subject:to:to:x-me-proxy:x-me-proxy :x-me-sender:x-me-sender:x-sasl-enc; s=fm3; t=1707737202; x= 1707823602; bh=53aq5SPtG4/3qpWh3Ta9AgMqYSvsnd1N9hocpLQbtFU=; b=h /R1AJortTnEkGsp6ECWYFPhtHKwpb0onR0ecTN49eyb9H4OvyCZiV5gfnFzUo7TM in2HGKxU7xTgfc9eycTezQQSZZZfZCvk2LSvY0CvraYo1o1KUaOHWh5NXrtxp11R mTBYq8HmYS0BfNDUwtLpI1Fhwt94/IlNJhqrMSUHPXzFArB+78dGcqWtTGoIDjPS ExdtXnWHi20LYb7gfPhf0uQOiprXSxNb0lYxOvE8y94iYNsYUBx/qSRmyk8rj8U1 FoxkQgUZF8RQAZRD5SQvnyN+wMI8P98kncsxtYMEoT3T7IHEKd7JCgLgNfSi/GTD DeSxdALr4c+7qgBBjPP6w== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledrudefgddviecutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecunecujfgurhepfffhvfevuffkgggtugfgjgesthekre dttddtjeenucfhrhhomheptehlvhgrrhhoucfjvghrrhgvrhgruceorghlvhhhvghrrhgv segrlhhvhhdrnhhoqdhiphdrohhrgheqnecuggftrfgrthhtvghrnheptddukeduteeufe evvdeufeelteeifeeijeekteetkeekvedtudduieetjefggfetnecuffhomhgrihhnpegv nhhtvghrphhrihhsvggusgdrtghomhdphhgrthgvshdqshhofhhtfigrrhgvrdgtohhmne cuvehluhhsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomheprghlvhhh vghrrhgvsegrlhhvhhdrnhhoqdhiphdrohhrgh X-ME-Proxy: Feedback-ID: ia2694551:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 12 Feb 2024 06:26:42 -0500 (EST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=alvh.no-ip.org; s=schmee; t=1707737200; bh=Ax+/5xHNhyxdXqO/AMTWxwKJMt3aCTQi6ZBV7SlCaEY=; h=Date:From:To:Cc:Subject:In-Reply-To:From; b=lgTODUhInnWF/iCTkhVTfUzVHga75Yp9MXKr3r9bc5jhldh+BIwY9iKdIc2vAmCcN 1MwdHOjWr3JlqGWroW0ICI26kCTqssM93qWlNw9Xr9CzdpzoenFki4RdcPzWVTpJOG 9swuGwqMnGeaLYreLwVpkCHjM3Spe9XkoDj9yrfutBqgLO4KZjpVAWGuhZqIY4ztxY Yihl76ZUDDY2YTvpDC5EgXE9q91hQnb3w15OHj7WnubaLcnp3ci2qThBAFNMzAkzgl g4Uvwm3G4vXnnnUqfcfB8BfXsxKmmJOfF5acGZlzhFJI0PTdLLlFKMCrsR6CsN4w4V OWO/1RK4aOb5g== Received: by schmee.alvh.no-ip.org (Postfix, from userid 1000) id 55CC0BA3; Mon, 12 Feb 2024 12:26:40 +0100 (CET) Date: Mon, 12 Feb 2024 12:26:40 +0100 From: Alvaro Herrera To: Shlok Kyal Cc: PostgreSQL-development Subject: Re: Add publisher and subscriber to glossary documentation. Message-ID: <202402121126.hrufq774kwuj@alvherre.pgsql> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Disposition: inline Content-Transfer-Encoding: 8bit In-Reply-To: List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hello On 2024-Feb-12, Shlok Kyal wrote: > There are several places where publisher and subscriber terms are used > across the documentation. But the publisher and subscriber were > missing in the documentation. I felt this should be added in the > glossary. I agree, but let's wordsmith those definitions first. Should these be "publisher node" and "subscriber node" instead? Do we want to define the term "node"? I think in everyday conversations we use "node" quite a lot, so maybe we do need an entry for it. (Maybe just suffices, plus add under instance "also called a node".) + Publisher + + + A node where publication is defined. + It replicates the publication changes to the subscriber node. Apart from deciding what to do with "node", what are "changes"? This doesn't seem very specific. + Subscriber + + + A node where subscription is defined. + It subscribe to one or more publications on a publisher node and pull the data + from the publications they subscribe to. Same issues as above, plus there are some grammar issues. I think these definitions should use the term "logical replication", which we don't currently define. We do have "replication" where we provide an overview of "logical replication". Maybe that's enough, but we should consider whether we want a separate definition of logical replication (I'm leaning towards not having one, but it's worth asking.) -- Álvaro Herrera Breisgau, Deutschland — https://www.EnterpriseDB.com/ "But static content is just dynamic content that isn't moving!" http://smylers.hates-software.com/2007/08/15/fe244d0c.html