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 1mdR0s-0006xs-2l for pgsql-admin@arkaria.postgresql.org; Thu, 21 Oct 2021 05:53:14 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1mdR0q-0002it-SP for pgsql-admin@arkaria.postgresql.org; Thu, 21 Oct 2021 05:53:12 +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 1mdQyU-0003wj-EA for pgsql-admin@lists.postgresql.org; Thu, 21 Oct 2021 05:50:46 +0000 Received: from mail-wm1-x32f.google.com ([2a00:1450:4864:20::32f]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1mdQyQ-000319-AI for pgsql-admin@postgresql.org; Thu, 21 Oct 2021 05:50:45 +0000 Received: by mail-wm1-x32f.google.com with SMTP id g79-20020a1c2052000000b00323023159e1so5393127wmg.2 for ; Wed, 20 Oct 2021 22:50:41 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=gNQVM65pv5TQLT1CTCXP3HKsJs736+Uz5RAHSRAJPFU=; b=unkLdhr7s4zRNm7ULpjtkA16MqaHy5BCDEj1HcRibgNu/kQVaU1hPt3AZzI5+xAR2X vk67HZ60tJt4tFeRXN43glt5fd+6NBCVueDO5GDZmDm/CkCvcSM0wunRAYD9oeuQmq6P 8ZScLfF7w6GOlYF8uhrUiGoiQiaS+2hYi8B+Br3B3xWq52WnL7XHFVcUoFMR0Xq1unOl bu/LfWQD8SQMWpBS4t38tqAfGpRsEj1OFS1rM4BSSuGg3AvdPnkFASyxfK7z/nKm6wkr Y2nguU/eLOS+258UOWLZ32YRuduzalXyvYhcoMZPvJ6XqKb8wk+r/vxDaMIZ/xyJyqv3 A6lw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=gNQVM65pv5TQLT1CTCXP3HKsJs736+Uz5RAHSRAJPFU=; b=gCCl4XMMnJNj50+32EaJPqf/foeiPpfvxiKErjq9rZYeqWK1iXr9EulPWyU84Wj1Kl dLLObPVVgk+0gKIA/4Lc/hn9qbKOZPloltZAPluYgNFXepoDT2i60bfxELIx5ctnMdYb x1fOohqz3FBNbDLGLUAK23ztPMSnu/HlzweV1VxA5gEJgeKS5agKy2FZ1XNLn2XyLV2x 5XTZvh4CAIp8vKlKFxxld58Lghry0k7pPL7IPxe2esCCDNmsUkLKOfjUiANlGIY6gqhI ROLngz6mHEiMinqLm+sx8jRa/NFvK6EWcaqAXmbweny0HciOWORqrilHfyiO1yvZGTXb 4EeA== X-Gm-Message-State: AOAM530t0rljHEisaTFm9v8885c+xYIm4dqEirxVGJQoc+DmIe5rFvLE H1vR534uMpruTFMxLTU9TyX8hrfFl3a5Bg== X-Google-Smtp-Source: ABdhPJw0YEPb2PaV1x3WX1IL6S3kJPu6SrWdHHL+35F/H+qHoMexVoIC3LJ7ZnO1v29gaOuslAaBLg== X-Received: by 2002:a1c:f31a:: with SMTP id q26mr4279858wmq.148.1634795439687; Wed, 20 Oct 2021 22:50:39 -0700 (PDT) Received: from localhost.localdomain (62-46-251-185.adsl.highway.telekom.at. [62.46.251.185]) by smtp.gmail.com with ESMTPSA id o6sm7166099wms.3.2021.10.20.22.50.39 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Wed, 20 Oct 2021 22:50:39 -0700 (PDT) Message-ID: <2855d4caf06b0c5dddc1cbb56809802d666960d0.camel@cybertec.at> Subject: Re: Can I make logical replication behave like synchronous streaming? From: Laurenz Albe To: sbob , pgsql-admin Date: Thu, 21 Oct 2021 07:50:38 +0200 In-Reply-To: <8381e958-e437-cc8c-f912-02bfd420cead@quadratum-braccas.com> References: <8381e958-e437-cc8c-f912-02bfd420cead@quadratum-braccas.com> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Wed, 2021-10-20 at 15:47 -0600, sbob wrote: > Does logical replication perform like synchronous streaming? If not can > I force it to do so? Sure! Set "application_name" to some name in the CONNECTION clause of CREATE SUBSCRIPTION and use that name in "synchronous_standby_names" on the primary. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com