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 1qF7KF-0002Vn-KO for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jun 2023 06:09:47 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1qF7KE-0005pz-E5 for pgsql-hackers@arkaria.postgresql.org; Fri, 30 Jun 2023 06:09:46 +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 1qF7KE-0005pq-4X for pgsql-hackers@lists.postgresql.org; Fri, 30 Jun 2023 06:09:46 +0000 Received: from mail-lf1-x12d.google.com ([2a00:1450:4864:20::12d]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.94.2) (envelope-from ) id 1qF7KB-001EAs-HT for pgsql-hackers@postgresql.org; Fri, 30 Jun 2023 06:09:44 +0000 Received: by mail-lf1-x12d.google.com with SMTP id 2adb3069b0e04-4f76a0a19d4so2320915e87.2 for ; Thu, 29 Jun 2023 23:09:43 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20221208; t=1688105382; x=1690697382; 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=J2+DXdgoKLI9dA5uMtyndYcPSNR3FM1vmkp1SaeGBtY=; b=NjpoQ5PduUuEXkobjlJCrF7Dkaw6QK5kMilp155eiBN7kxwDQaX8OoHQsEiZVyR5mS odEYchxKgF8iMbZXFCIHTWm2OHrSAetkuFTt4Pt0gaN9YTFfO+4kLwlEZOfOt8JP5hZ8 4Jl+ytslmR4gXCyCJ96f6KM+GGwZA8oDsC1qEOUqLv+80Ep8c/tP/dlAOuXKormpkpsi wubxQkBzE2i6hVJ68WvbpL3J57qENH2DGnIOrZqEVSjYfSrDiLymnUHTYFIn/zokHyyc VZffw97uV3hTAeeHlVrecqGSl+D+QIJ503XV4lozKvutf938HYdt1VFxQ5fheL1wUMVb ciUA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20221208; t=1688105382; x=1690697382; 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=J2+DXdgoKLI9dA5uMtyndYcPSNR3FM1vmkp1SaeGBtY=; b=MmdkXjDkMHG1AvJWWrPBCwtsgHzslpUx8um4thctigQODvhz4u8113H65FhedNIKdZ Seh3TR52DNrA5EeKcXs90UCarKjBL8RUpKq9zKLSNrJFQCS96OJZHrjn7uLxVOh1wJb1 eyy9NZc14DxiNm4h3nqeuMFiZbc8Lf9T7/h9OUyvDeiaI9nuWlBzPQry/VfgFYrWt+fU ZpeIoE/yBCflk9kwM/Am6DPlH/eG7UqwlsZ+Y/9+8YxKdjsj4/8ffDq2o+bPP5nJ14fI OAvu6jn0P8WQ0Phzrsp4EzFdRaX+aL7gSfMHm4RFOSQr/xLpnVzPensvgB+CSC4pZtls REXg== X-Gm-Message-State: ABy/qLZg3rTVDa3ZLcMIA+dR9gxJcr/g1sYa7M0GVt9FHoF5LdLcfjsx 8rjzJpPDwjID06NE+XEwdi0= X-Google-Smtp-Source: APBJJlEr7lqEQ/J7CV7RTs67Uw0tyyh803Us5kjLapn3qncpZIyQuL02h6/Iql3Q4uZqGWD8o/baLA== X-Received: by 2002:a05:6512:74a:b0:4f8:5af4:73f1 with SMTP id c10-20020a056512074a00b004f85af473f1mr1282665lfs.32.1688105381531; Thu, 29 Jun 2023 23:09:41 -0700 (PDT) Received: from ?IPV6:2a01:cb11:55e:1700:65d9:60f0:89c5:1be? ([2a01:cb11:55e:1700:65d9:60f0:89c5:1be]) by smtp.gmail.com with ESMTPSA id c1-20020a05600c0ac100b003fba6a0c881sm8900763wmr.43.2023.06.29.23.09.40 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Thu, 29 Jun 2023 23:09:41 -0700 (PDT) Message-ID: Date: Fri, 30 Jun 2023 08:09:40 +0200 MIME-Version: 1.0 User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:102.0) Gecko/20100101 Thunderbird/102.12.0 Subject: Re: Synchronizing slots from primary to standby Content-Language: en-US To: "Hayato Kuroda (Fujitsu)" Cc: Andres Freund , pgsql-hackers , Peter Eisentraut , Bruce Momjian , Ashutosh Sharma , Amit Kapila References: <514f6f2f-6833-4539-39f1-96cd1e011f23@enterprisedb.com> <18dbc929-a281-8552-4f1d-7e4d0e4eedba@enterprisedb.com> <646acd8d-9896-ed8d-2ab4-0bf11b3285d4@enterprisedb.com> <20220205195944.drwc3psrb5udt2cw@alap3.anarazel.de> <20220207203222.22aktwxrt3fcllru@alap3.anarazel.de> From: "Drouvot, Bertrand" In-Reply-To: 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 Hi Kuroda-san, On 6/29/23 12:22 PM, Hayato Kuroda (Fujitsu) wrote: > Dear Drouvot, > > Hi, I'm also interested in the feature. Followings are my high-level comments. > I did not mention some detailed notations because this patch is not at the stage. > And very sorry that I could not follow all of this discussions. > Thanks for looking at it and your feedback! All I've done so far is to provide a re-based version in April of the existing patch. I'll have a closer look at the code, at your feedback and Amit's one while working on the new version that will: - take care of slot invalidation - ensure that synchronized slot cant' be consumed until the standby gets promoted as discussed up-thread. Regards, -- Bertrand Drouvot PostgreSQL Contributors Team RDS Open Source Databases Amazon Web Services: https://aws.amazon.com