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 1rB9CZ-009cT0-3m for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Dec 2023 07:53:43 +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 1rB9CX-00Fb7I-NZ for pgsql-hackers@arkaria.postgresql.org; Thu, 07 Dec 2023 07:53:41 +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 1rB9CX-00Fb72-E2 for pgsql-hackers@lists.postgresql.org; Thu, 07 Dec 2023 07:53:41 +0000 Received: from mail-wm1-x335.google.com ([2a00:1450:4864:20::335]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1rB9CU-009DCo-T8 for pgsql-hackers@postgresql.org; Thu, 07 Dec 2023 07:53:40 +0000 Received: by mail-wm1-x335.google.com with SMTP id 5b1f17b1804b1-40c256ffdbcso6940645e9.2 for ; Wed, 06 Dec 2023 23:53:38 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1701935617; x=1702540417; darn=postgresql.org; h=content-transfer-encoding:in-reply-to:from:references:cc:to :content-language:subject:user-agent:mime-version:date:message-id :from:to:cc:subject:date:message-id:reply-to; bh=yByL4ym53X82UDtbfB1ckAYAtwCtvjVrXtAbnjOQzRM=; b=mwY7Nengt0i3C8sAtoifEZDz8bBsY0+V5EXE7R/Yz8BLCiMQK1cWYwI++TuKqZXZ1/ FMnHcEsePQxxR/jKheO/0xZ5OuTt2c0+wnItxQI9uMia9N5IKCpLRu1c7shhK9PK439y DZ9Pdp+sfCje9tuB1Y7TDojau1nFbfWNU7OlQMpBF5syxUYrx1MWQLnL4LdPIG+zXmZc 6pB/rDgl35gn9VTa6AbWv8YlPrpulNq9qV+s4QFqjPhr2DStl1e3Rql0+zN84GdiIs8b CxnG8G+XmbqkK7M7EzsImkW+oxTkUhbiZZg7bTqlipt+pWtOCxPXKsc8/95FZu6l1njF 7o0g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1701935617; x=1702540417; h=content-transfer-encoding:in-reply-to:from:references:cc: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=yByL4ym53X82UDtbfB1ckAYAtwCtvjVrXtAbnjOQzRM=; b=tZiy/mODrY+588ZQWeS5DeW33JqO+gDPMcY0rdXzHSv0P+rbI+AgZtlL3BkZJ5s1tn GG6Kj9+2wPdPya4w4lfKGfBPkldDUt1FOoduyz0LZyjNgpjjkMuvr2/hWxkNicJP7cTM T2uQNPo2+TwRI9XQHcdleaW3v28+Ck2RWaW5S5A2nFF1evTmHwWYZetAjDer0eozAZWB iBJQ6zDaYryn8ZJ2kcd0XCqTn28tsmmLmBTZQdjvxllqd9ks8r+dM+YypDk4VD0noPMO OQU9603KIqDd2GXX9Qz0nym0p4Kc1dVa4tugulN6AQOp22Qm43GUw+8HiCuNe86qqaK5 S5lw== X-Gm-Message-State: AOJu0YyQ4EkP9uTYB0ponaScFpP6+xvmo2tE1EHo4Olugc91or2Dc2wd aq9rKRJRZHCQnYtKDyZWj8g= X-Google-Smtp-Source: AGHT+IF6Azd8EPUjluF3VuvZ9MOVW0BZY4fb6w+RRg0tLnpWUyqoVfBFvlD84JKTfzgaa7O3MwPNFw== X-Received: by 2002:a05:600c:1f8f:b0:40b:5e21:d345 with SMTP id je15-20020a05600c1f8f00b0040b5e21d345mr1230463wmb.78.1701935617273; Wed, 06 Dec 2023 23:53:37 -0800 (PST) Received: from ?IPV6:2a01:cb11:192:7000:a0c2:3d14:518:c3b7? ([2a01:cb11:192:7000:a0c2:3d14:518:c3b7]) by smtp.gmail.com with ESMTPSA id ay41-20020a05600c1e2900b004063cd8105csm1058855wmb.22.2023.12.06.23.53.36 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 06 Dec 2023 23:53:36 -0800 (PST) Message-ID: <0dd82076-4f70-4e9c-bfbc-29bf94d6a047@gmail.com> Date: Thu, 7 Dec 2023 08:53:36 +0100 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Synchronizing slots from primary to standby Content-Language: en-US To: shveta malik Cc: Amit Kapila , Nisha Moond , "Zhijie Hou (Fujitsu)" , Peter Smith , "Hayato Kuroda (Fujitsu)" , Bharath Rupireddy , Peter Eisentraut , Bruce Momjian , Ashutosh Sharma , Andres Freund , pgsql-hackers , Ajin Cherian , Alvaro Herrera References: <828dcda4-50c2-4069-bdc3-9e8c90c943d7@gmail.com> <6694284d-c847-42df-8f76-6efa8eeeb0df@gmail.com> <2fdc471d-2eee-4c29-9f26-d7f5dcc8cd53@gmail.com> From: "Drouvot, Bertrand" In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk Hi, On 12/6/23 12:23 PM, shveta malik wrote: > On Wed, Dec 6, 2023 at 4:28 PM shveta malik wrote: > > > PFA v43, changes are: Thanks! > > v43-001: > 1) Support of 'failover' dump in pg_dump. It was missing earlier. > > v43-002: > 1) Slot-sync worker now checks validity of primary_slot_name by > connecting to primary, once during its start and later if > primary_slot_name GUC is changed. I gave a second thought on it and yeah that sounds like the best option (as compare to relying on the walreceiver being up or down). Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com