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 1tv7Bj-000MPU-QX for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Mar 2025 04:07:23 +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 1tv7Bh-00GeQ2-9b for pgsql-hackers@arkaria.postgresql.org; Thu, 20 Mar 2025 04:07:21 +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 1tv7Bg-00GePu-Vd for pgsql-hackers@lists.postgresql.org; Thu, 20 Mar 2025 04:07:20 +0000 Received: from mail-yw1-x1130.google.com ([2607:f8b0:4864:20::1130]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.96) (envelope-from ) id 1tv7Bf-0003Qw-1l for pgsql-hackers@lists.postgresql.org; Thu, 20 Mar 2025 04:07:20 +0000 Received: by mail-yw1-x1130.google.com with SMTP id 00721157ae682-6fd80f30ba5so2085987b3.3 for ; Wed, 19 Mar 2025 21:07:19 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1742443638; x=1743048438; darn=lists.postgresql.org; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:from:to:cc:subject:date:message-id:reply-to; bh=J3YEwE1YrO8W/V+unIqQVk3KCdfynJmWzvDqShwyfC4=; b=i/yL3zCqWf8TtdQATudGQNgs08+PnhdfHjM0zK0XuQ5+jN41wKwjrl7ltozdDLb8DB CCASZkOx+HyOiT5HI9/FAPm7cISJXD2HrsXgPMkTUTO/O3iFld8NZLqqhObj98tpiZwz ElLInUjCvDKmzqA/ay9Bg7Gm9ZJDGn54rxUPX1MXmJAABJZahZmQnyWpLS0HNq4X/0Fp 3MEVoE/UBQj0MvaD2Qu8XiiL48K9VlNAuet14qzIIuTmw5O4gNa/nHrQbEQZjoKH2DWC 2EcFs4V3VWJzdCKqDeNh4YPUrqBU2m9tROyCxT5CVREM6eA1NuwzcQfWwiAOET4RI/7l kJ5A== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1742443638; x=1743048438; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-message-state:from:to:cc:subject:date:message-id :reply-to; bh=J3YEwE1YrO8W/V+unIqQVk3KCdfynJmWzvDqShwyfC4=; b=SKg7mo3iNoTWdZdyvuHHL7ndaK/r+FJHD6zhcgEDhwedpbpUOeSY/hn0cPtg8O8g4u wFoelclxuP/esggAtBNf2tYznc0i74Uj2uvDDKzCg/wvU92ugMVl3YVnGhsMul68iv+g cWKt+hQUb8RD4myVgKMW5XVzXi6+s56vnzD4Xd7ORZW/K+j3pGYrEs7KlqWmiPqSyk5y +G4hMCSgf4BzNBPIFOi1pyC+/oOjjq95hZ3lUPPQfIvib8LsXAohSJ2ExUZTvkWSpzxR HWckeyw7vUGKa5jnQmSpkJIrVqQ7jxWlbvLBOOSTRT6+HI21V7CEZopZHkKb594RGzJH KuLg== X-Forwarded-Encrypted: i=1; AJvYcCWV8YelR3RqeDBnTy8bdMNRJPLWXbk+8RG55AYKkeKZ+sSp/Y4o4g7OdKQpCJMuD+eBz12FaKND9vGwkpWr@lists.postgresql.org X-Gm-Message-State: AOJu0Yzt7XKOZ/jL5Zn7rIyZo2+zmBM1xXz1j005I/BpT0Sa2ixcgVrE kUspq/Fe2Yi3ey1yU9AIBALItraydlGJqvFRCO0YmiWE8pRS96ORzszWoBkWKRJeYRsWs9sW/jq 5dbmNjo12XlCkSFaf4+H7ruqT35M= X-Gm-Gg: ASbGncsgyKDvDyRC8w7xyO1tkfst3D6IWNHjlcBymfZf/tTopjje6scG6zD9PTfs/u7 mG9b+fQt8i3VkxA5paNF42XApI+4bD+4W4o2YjQhRquK9rqjdvAwTcqPV3uO0GftfM9AetLnMEn XfIoFftQZvVr7FL/X3fzTHGKBdVQ== X-Google-Smtp-Source: AGHT+IHSvBi3PuXUAdIEFELAL3CwXebTCpMhI+XL7bM2jodIDRMrdhcixd+Kfj+ctGlqBHvzwMKFfrpYioR0cktAUrk= X-Received: by 2002:a05:690c:4d89:b0:6fb:4c11:61cf with SMTP id 00721157ae682-700ac5fc40cmr24395767b3.19.1742443638556; Wed, 19 Mar 2025 21:07:18 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: vignesh C Date: Thu, 20 Mar 2025 09:37:04 +0530 X-Gm-Features: AQ5f1JqF2jcI6fxhZL0mJMB0_HDc4f-5u2qeZGEh9DyTVrxDwsZTQ1PoQKq1UV4 Message-ID: Subject: Re: Adding a '--clean-publisher-objects' option to 'pg_createsubscriber' utility. To: Shubham Khanna Cc: "Hayato Kuroda (Fujitsu)" , "David G. Johnston" , Euler Taveira , Peter Smith , Nisha Moond , Shlok Kyal , PostgreSQL Hackers , Amit Kapila Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Thu, 20 Mar 2025 at 09:06, Shubham Khanna wrote: > > The attached patch contains the suggested changes. Couple of minor comments: 1) The second and third line comments can be in same line: +# Create user-defined publications, wait for streaming replication to sync them +# to the standby, then verify that '--remove' +# removes them. 2) This comment can be in a single line: +# In passing, also test the --enable-two-phase option and +# --remove option Regards, Vignesh