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 1rhgfl-00CpHp-Q5 for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Mar 2024 02:06: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 1rhgfj-004PGb-Hl for pgsql-hackers@arkaria.postgresql.org; Wed, 06 Mar 2024 02:06:20 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhgfi-004PFk-0w for pgsql-hackers@lists.postgresql.org; Wed, 06 Mar 2024 02:06:19 +0000 Received: from wfhigh2-smtp.messagingengine.com ([64.147.123.153]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1rhgfc-002zY1-Mr for pgsql-hackers@lists.postgresql.org; Wed, 06 Mar 2024 02:06:17 +0000 Received: from compute2.internal (compute2.nyi.internal [10.202.2.46]) by mailfhigh.west.internal (Postfix) with ESMTP id EB9E01800095; Tue, 5 Mar 2024 21:06:07 -0500 (EST) Received: from imap49 ([10.202.2.99]) by compute2.internal (MEProxy); Tue, 05 Mar 2024 21:06:08 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=eulerto.com; h= cc:cc:content-type:content-type:date:date:from:from:in-reply-to :in-reply-to:message-id:mime-version:references:reply-to:subject :subject:to:to; s=fm2; t=1709690767; x=1709777167; bh=ZIKXPdLf4L TzAu+poW4bO+3ljAwea61HrIe/QXzBKtg=; b=p4917NXiK5ehFjVg87EWptJYGN VdhDCXP8yY+n1iOFypGHBx5hg3g5J/xiTLwCWOyGkztPf4QYPQ3V67sMRyqUpv4U jOSaVgN4qJlKL6fRMrWZGf9+gGYihUxA77cvmYQOJv2JGM/6nf5MTG0kbWw6PiHx q+AcwneI+OQj3yu0yhf7oM40ROGW8MDbkX+zkQD072UDT0yvkzAx5qNJtgXE8f6z SOgMzCCsEO4zl1lInEQWBjzzsrxC1WOEbCJCVLf/U5pUGKaULjf8yDxSF/qrhrar qph4UsolXDxKAP8AGwzusPGfZ/Oxhs1UWC+sUqTxvapTfoNwHrGMN3lzPdvA== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:cc:content-type:content-type:date:date :feedback-id:feedback-id:from:from:in-reply-to:in-reply-to :message-id:mime-version:references:reply-to:subject:subject:to :to:x-me-proxy:x-me-proxy:x-me-sender:x-me-sender:x-sasl-enc; s= fm1; t=1709690767; x=1709777167; bh=ZIKXPdLf4LTzAu+poW4bO+3ljAwe a61HrIe/QXzBKtg=; b=ldlvXrVR3wQEGjuLwkuAFytmJXdyX6I4mpgdfzyws5Q1 gDSXCJmA4ZlNtXy4fSQ6FfWlN3ZvPGpzhBXdaSxn4tEEXUFJ5LvAd328rbSpJrBQ 4sXlCCx32dCA9egDMY5eugTMgIQ04f6GziXBr30Co439IJYyF4iBVXfBV87buu4h /Du/PPPDJb0yiQoNi0L562Ze74Iaia5vp3TExbTNpii+Qn8hbhoiZh3m+ahZDeft G1v8uhmVBhavJce1+Xh0sHtkrrX637Gjp/UBtY4/g7dy/uOKfpI+AVd6L9Bry+gr VoE4uoKFn7O5Ix+Nlo08bpFJcXJCfgonx8jD6zqBaQ== X-ME-Sender: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgedvledriedtgdegvdcutefuodetggdotefrodftvf curfhrohhfihhlvgemucfhrghsthforghilhdpqfgfvfdpuffrtefokffrpgfnqfghnecu uegrihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenuc fjughrpefofgggkfgjfhffhffvvefutgesrgdtreerreertdenucfhrhhomhepfdfguhhl vghrucfvrghvvghirhgrfdcuoegvuhhlvghrsegvuhhlvghrthhordgtohhmqeenucggtf frrghtthgvrhhnpefgffejvdeivdekvdeivdetudeikeduieevtdfhhfduvdetgeelteei ffekgefhvdenucffohhmrghinhepvghnthgvrhhprhhishgvuggsrdgtohhmnecuvehluh hsthgvrhfuihiivgeptdenucfrrghrrghmpehmrghilhhfrhhomhepvghulhgvrhesvghu lhgvrhhtohdrtghomh X-ME-Proxy: Feedback-ID: i0c21471d:Fastmail Received: by mailuser.nyi.internal (Postfix, from userid 501) id 7693415A0093; Tue, 5 Mar 2024 21:06:06 -0500 (EST) X-Mailer: MessagingEngine.com Webmail Interface User-Agent: Cyrus-JMAP/3.11.0-alpha0-208-g3f1d79aedb-fm-20240301.002-g3f1d79ae MIME-Version: 1.0 Message-Id: <0f2b512c-bbb3-470d-8514-7eabc30a96bf@app.fastmail.com> In-Reply-To: References: <9a9c7e65-c47b-4400-a63e-ac6169c0860e@app.fastmail.com> <8d8d9960-8130-4216-b0e4-adf36b8b1c43@app.fastmail.com> <370673e8-e2da-4249-8f07-cb67e9d9c20e@app.fastmail.com> <34075bd4-c85d-4654-a782-0cd6713b2c89@app.fastmail.com> <2edde173-5ff9-45fd-b881-cd04eb13049f@app.fastmail.com> <2231a04b-f2d4-4a4e-b5cd-56be8b002427@app.fastmail.com> Date: Tue, 05 Mar 2024 23:05:42 -0300 From: "Euler Taveira" To: "'Shubham Khanna'" Cc: "kuroda.hayato@fujitsu.com" , "vignesh C" , "pgsql-hackers@lists.postgresql.org" , "Michael Paquier" , "Peter Eisentraut" , "Andres Freund" , "Ashutosh Bapat" , "Amit Kapila" , "Shlok Kyal" , =?UTF-8?Q?Fabr=C3=ADzio_de_Royes_Mello?= Subject: Re: speed up a logical replica setup Content-Type: multipart/alternative; boundary=a3c9e473ce7b4bccbfa42a048c8cb35b List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --a3c9e473ce7b4bccbfa42a048c8cb35b Content-Type: text/plain On Tue, Mar 5, 2024, at 12:48 AM, Shubham Khanna wrote: > I applied the v25 patch and did RUN the 'pg_createsubscriber' command. > I was unable to execute it and experienced the following error: > > $ ./pg_createsubscriber -D node2/ -P "host=localhost port=5432 > dbname=postgres" -d postgres -d db1 -p 9000 -r > ./pg_createsubscriber: invalid option -- 'p' > pg_createsubscriber: hint: Try "pg_createsubscriber --help" for more > information. Oops. Good catch! I will post an updated patch soon. -- Euler Taveira EDB https://www.enterprisedb.com/ --a3c9e473ce7b4bccbfa42a048c8cb35b Content-Type: text/html Content-Transfer-Encoding: quoted-printable
On Tue, Mar 5, = 2024, at 12:48 AM, Shubham Khanna wrote:
I applied the v25 patch and did RUN the 'p= g_createsubscriber' command.
I was unable to execute it an= d experienced the following error:

$ ./pg_c= reatesubscriber -D node2/ -P "host=3Dlocalhost port=3D5432
dbname=3Dpostgres"  -d postgres -d db1 -p 9000 -r
./= pg_createsubscriber: invalid option -- 'p'
pg_createsubscr= iber: hint: Try "pg_createsubscriber --help" for more
info= rmation.

Oops. Good catch! I w= ill post an updated patch soon.


--
Euler Taveira
EDB  = ; https://www.enterprisedb.com= /

--a3c9e473ce7b4bccbfa42a048c8cb35b--