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 1pDaCq-0007fq-I0 for pgsql-general@arkaria.postgresql.org; Fri, 06 Jan 2023 00:03:32 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1pDaCo-0007yt-PW for pgsql-general@arkaria.postgresql.org; Fri, 06 Jan 2023 00:03:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1pDaCo-0007yk-FN for pgsql-general@lists.postgresql.org; Fri, 06 Jan 2023 00:03:30 +0000 Received: from mail-yw1-x112d.google.com ([2607:f8b0:4864:20::112d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1pDaCm-0002U4-BA for pgsql-general@lists.postgresql.org; Fri, 06 Jan 2023 00:03:29 +0000 Received: by mail-yw1-x112d.google.com with SMTP id 00721157ae682-4c15c4fc8ccso2172227b3.4 for ; Thu, 05 Jan 2023 16:03:28 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=hcBQMlk2MriELfRm5ah2YjKaeLTYg2TAUZ1nQCeEnlg=; b=gHsMOYSOPS+gKnjOpmmSWjFMhVKJfB8yvyzfpEtWbKlGXl+RBmKd9tfabQ3T3dHnCW YI5NuYm3QTZJvu/5/+Qn4ilX2EdQAzbAnHfOI0t2SAAoQC0Gprh9habNvfBdPn1rjoaX l7jOShJkCrclH/WurcC/fzRXyjZeGAo89znslmEJKQTZBA4yrZ6LZNEyvu27/IsgtQ6n Ne03kJvkQHyNgjGUdtSK5Th8ECKZkozNA4Rr4NL4nvv8OblKQcaKgO3rIVwtI9mwHo+Z ky5QIJ1igcpdjdRepuaz7t7L/nyg5W5L4ZcCBJNT0cmPRKRf4i/X4eP0WCbIyZyYg7nP SMVQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:in-reply-to:from:references:to :content-language:subject:user-agent:mime-version:date:message-id :x-gm-message-state:from:to:cc:subject:date:message-id:reply-to; bh=hcBQMlk2MriELfRm5ah2YjKaeLTYg2TAUZ1nQCeEnlg=; b=aydUkx+dtt39Ag/zmszNxyLpGZqW96RHHaYn9cWHEzlgGFyyBd8IjQD2Zire59tM8p BegTuZC1ns9Fmawvwstn2eZscQm6RJMEkcqBnGxugdNdFttP5vnVQ0r3MBD5/OU3vCuf FdmkGfvEo0zkeQFwNV8QuCUoLVoHvMoKs3cQhbZG3BrXP5wLdCK6LV8zo/hSFx6Kx6bv pbsnpLV3EbXvbkk3qOHzb08WA5W2alvFdTvn+zBdVHvsOGNdGmkalu6L58pMcPVZXk5a 6n5SRLhD8LW90BwOMKf4Xtr+MtvBmwFnydkGWqUQfpKXkXbyMww7FXadCJR7qeOJvfEl UEgg== X-Gm-Message-State: AFqh2koqDtOzVKGHbJIPShNQrbkUKx+HcDkXcQYX4TKNuYjH/j6KoECq KGjMO7l8wpdtSXbyx01tvi1Rm1UaDdGZfA== X-Google-Smtp-Source: AMrXdXttLJLjlF4gfSl4LBhgjrAPN9SepMRzLu2vFFQTU7KeUF8bJLHPyJQIMUTWJO1SEuVumzD5mw== X-Received: by 2002:a0d:fdc3:0:b0:45f:e40d:a5 with SMTP id n186-20020a0dfdc3000000b0045fe40d00a5mr2518070ywf.16.1672963407123; Thu, 05 Jan 2023 16:03:27 -0800 (PST) Received: from [192.168.1.66] (108-250-206-84.lightspeed.nworla.sbcglobal.net. [108.250.206.84]) by smtp.googlemail.com with ESMTPSA id pi27-20020a05620a379b00b006e8f8ca8287sm26192337qkn.120.2023.01.05.16.03.26 for (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 05 Jan 2023 16:03:26 -0800 (PST) Message-ID: <927ec1cd-61fc-879f-d1c6-6c21cd5716bf@gmail.com> Date: Thu, 5 Jan 2023 18:03:26 -0600 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.2.2 Subject: Re: PG replicas and transactions atomicity Content-Language: en-US To: pgsql-general@lists.postgresql.org References: <5E470587-CEAF-4FAA-8111-100124A0E51B@thebuild.com> From: Ron In-Reply-To: <5E470587-CEAF-4FAA-8111-100124A0E51B@thebuild.com> Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 1/5/23 14:09, Christophe Pettus wrote: >> On Jan 5, 2023, at 12:07, Louis Laborde wrote: >> >> Are PG replicas updated atomically following the same transactions boundaries as the source DB ? > Yes. The same transactional guarantees apply to the replica as do to the original transactions on the primary. Even in asynchronous replication? -- Born in Arizona, moved to Babylonia.