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 1opl9B-0002kz-QJ for pgsql-admin@arkaria.postgresql.org; Tue, 01 Nov 2022 06:53:17 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1opl9A-0003FV-NN for pgsql-admin@arkaria.postgresql.org; Tue, 01 Nov 2022 06:53:16 +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 1opl9A-0003FM-CR for pgsql-admin@lists.postgresql.org; Tue, 01 Nov 2022 06:53:16 +0000 Received: from mail-wr1-x435.google.com ([2a00:1450:4864:20::435]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1opl98-000152-JP for pgsql-admin@lists.postgresql.org; Tue, 01 Nov 2022 06:53:15 +0000 Received: by mail-wr1-x435.google.com with SMTP id h9so18945293wrt.0 for ; Mon, 31 Oct 2022 23:53:14 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20210112.gappssmtp.com; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:to:from:subject:message-id:from:to:cc:subject:date :message-id:reply-to; bh=ElviOsVdJSKOmsbDwUQf+1HxvUqKWnYPn+lShbIqy84=; b=srMmCNn2OtIv1dF8AUmpCcLMVJeCZYqST2/zQobT7KVH6bIuUzjwXG+Y4716m/Pq8R h3HcAdAxamMWRhoFY+81GqyPsGLoHmV5Op0V/dd7Qv3gFs3SYVcc76XqNTcOzQxgEC9L L+JtHIdVUoImAilISdpRHGX6V/yFnAkqxcYAzX6XS0XSXDk7j1kmrSQL9nQNmqxI2Pg3 hR2M7KaxnQc1PDkKE6/koIR83sSXaW8B6QcI013vmJ0T6822Q6UdHwTy3gaM9G+8sWG6 O6ZEi+O7CRr4Gt81QqIe35zXgV6JJ202GpwE+z65SmLR+55WGHTilOEk7BQ27WRjhA7W +9jQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20210112; h=content-transfer-encoding:mime-version:user-agent:references :in-reply-to:date:to:from:subject:message-id:x-gm-message-state:from :to:cc:subject:date:message-id:reply-to; bh=ElviOsVdJSKOmsbDwUQf+1HxvUqKWnYPn+lShbIqy84=; b=U82gOqIu/x+kEe8R88wobJR/ma+Jv835f9SnsYC46JPVl993sanZ9h5EwDkFc7y7rx aj/q05sdXB82qDFoEz6SZjidewDweZch2yv7YS/pAiubAbmgvlLX2BtzCBYH4Ani3mDq 0TT8Geh/JEozQ26yRVM+db4jzYcOzzvQYO7lrc9hO9un+TlRplsMjLxz1oLpZ/AAfZK+ 4gXumHayn4U/TCR+69UchIhCKR7PIzEzHiOxbcF7woTfTKOjZSCQTImgVq2P0g7NgIz1 b+Ias8CnsYPMBHjFTPzAbrP1/mNncHLB2ys8aAWbjKfOzcCLXHfHpOFwIAI2ZMGxzB5t z4dQ== X-Gm-Message-State: ACrzQf2+pVLc1m71dZAHbdekfP5Cc//XDt4vOFDROYPQjoxRtsk/fPe1 rB11uhtO14z5lCFllWnsL6AKvQ== X-Google-Smtp-Source: AMsMyM5go3T/BmfJgbS9+PltPAxjo2BOxEfW6ukKcOrD6+x7/xuWdMhBWGYWNaAGTWMGj0s02Q4ryQ== X-Received: by 2002:a5d:52d0:0:b0:21e:4923:fa09 with SMTP id r16-20020a5d52d0000000b0021e4923fa09mr10799995wrv.244.1667285593931; Mon, 31 Oct 2022 23:53:13 -0700 (PDT) Received: from localhost.localdomain (178-190-182-20.adsl.highway.telekom.at. [178.190.182.20]) by smtp.gmail.com with ESMTPSA id bq9-20020a5d5a09000000b0022ae0965a8asm9425861wrb.24.2022.10.31.23.53.13 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 31 Oct 2022 23:53:13 -0700 (PDT) Message-ID: Subject: Re: [External] Re: WAL Replication query From: Laurenz Albe To: Sacheen Birhade , KK CHN , "pgsql-admin@lists.postgresql.org" Date: Tue, 01 Nov 2022 07:53:12 +0100 In-Reply-To: References: <88faef33e966796226022d6e7f3e32ad6c59fcfd.camel@cybertec.at> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.42.4 (3.42.4-2.fc35) 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 Tue, 2022-11-01 at 06:44 +0000, Sacheen Birhade wrote: > If replication is in asynchronous then there will be data loss, right Laurenz? Why? The data will perhaps show up on the standby a little later, but why is that data loss? Remember that the question was about replication, and there was no mention of failover. Yours, Laurenz Albe