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.96) (envelope-from ) id 1vrvUL-00DH3b-1O for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Feb 2026 10:05:57 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vrvUK-0012zj-0c for pgsql-hackers@arkaria.postgresql.org; Mon, 16 Feb 2026 10:05:56 +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.96) (envelope-from ) id 1vrvUJ-0012zZ-2k for pgsql-hackers@lists.postgresql.org; Mon, 16 Feb 2026 10:05:56 +0000 Received: from mail-yw1-x1133.google.com ([2607:f8b0:4864:20::1133]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vrugu-00000000rM5-19PS for pgsql-hackers@lists.postgresql.org; Mon, 16 Feb 2026 09:14:54 +0000 Received: by mail-yw1-x1133.google.com with SMTP id 00721157ae682-79495b1aaa7so27210187b3.1 for ; Mon, 16 Feb 2026 01:14:53 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1771233292; cv=none; d=google.com; s=arc-20240605; b=FREcBuA9agXHa/ILUWtU5UoNUiuj+EtdzxBAZWif/H5AuurGCSDjVG6CMWnigM35Tk qU02AUBcQvoIl/rUNL8NgOpagmRlVNBt+R86tqLSqMFpQPAScdSamLZZPthkyX3GSFE8 o1Ghzu7w3wC3djyFr4M/hVdhwIqxeeXPQpJb3N8aKtifbApUgpas/Ved1iOfw3tVpK0x 8nMDYc/gPLNLAkhhAXvXIAHZFdZRpGlduNCxDBUjbvOSfAc4JyLavcUtO0c9Xhtjl4rz s7ZgJRZh/xi21O0lPF5mTQuMqccfgC4mGtLtCYZiE35sQo4ED8Jp6+3LFgdMnk59V8Xy O2Ug== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:dkim-signature; bh=EJ+YmhckF9HjlsI0omNatME9UBcpYxkPu+Na+zeiY18=; fh=uPdi50ZRuEmRFn1lghNvOol8e/wSPMsIxlvmd0AMuMA=; b=gh4slJG7hv6YJY0+b3jKJfbnUi9qvDDMU84b7yKaI+DkIDVMqjrsi2OKm7z1gM7JMZ pR0oskxwWNN8In711ZG2U7nOpZsN1OHQxIUmRIHkvTC5sSH3T6orUJiNxu/tatfyUSMp mZ2Qwv0X0Cofp7TLQzMQw42wISR6YWzUS7BmO+3bdveZwg28C2MWCJF+2dLYxVHtYN/R nbdsbCovhxntiYVEbR9Hrrhz/QBD02D/eJqqB5pUOSbiQ4kjrEG3fmYq1SxIORNcxUf3 Vpx4NlQzptakZan16l9o5AgrpPVq95yM+EQa/8BIE3tpZ6D+bDteUDDluBi7msbcEEFg kQ3A==; darn=lists.postgresql.org ARC-Authentication-Results: i=1; mx.google.com; arc=none DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20230601; t=1771233292; x=1771838092; 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=EJ+YmhckF9HjlsI0omNatME9UBcpYxkPu+Na+zeiY18=; b=DIi5MhWDRC9gM2Xx3Dj5k3IOjFYjqN2fiiZg9tcgOORVTtHHBSR1NbcQ6x5WMOv/tu MC/h7X5SB7A17oHO1w6bVVoLN4EiDf7fhUS0iGdGo+nN/Hw2TUwbGPz74ERcfBbU25/W pwVBtL1fUyzOhuv+Nuvb/msZ64FZZhOmlCId9/q64A2GvrRiq5ArzISV+e75Rl9Xn6zk CynnckbVoGKlX7z9BfG6I6lbKq3XIa1QhJdPSXOJCkJMnTGyvxtkxPcBYymSROnuLwAb D+LMDS4VHQidWK3ymZjfXi8Snp0q/QMOiK5AtRgAHRpsfdFMkTmbs9ErKRmV2XXAp+T9 G7qg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1771233292; x=1771838092; h=cc:to:subject:message-id:date:from:in-reply-to:references :mime-version:x-gm-gg:x-gm-message-state:from:to:cc:subject:date :message-id:reply-to; bh=EJ+YmhckF9HjlsI0omNatME9UBcpYxkPu+Na+zeiY18=; b=ZkhzzX8XBIy8+CuTv95abMsVdbInhXlsZSef4kNcAPzvL4037bY+FI+d1m+PDxikrq zdb332lvAxpQ0C/qDT1te2zEY5bmkvzLTLeGKg3oDakJiTe9Bk4MWAhsBuc7whf8Frkc mihQscMqdpAXVgHgwtFr4UEKPb2T0gVvxp+PXYDX2C60ztFbvS8wn9a8wk0++NMcmM7S DX9rCziVcOtAizHBkRThp0+u4LyTmEcgm5AGiBFRN/3eBAiGluZpgHfVUrou0WlAIW3/ jsdi9+6KOoDuo85n9cE59QEp36s2k5OLzb+5SUeHG+y1NqDYDwFhfv9UOmVT2SqSlU/0 Vgzg== X-Forwarded-Encrypted: i=1; AJvYcCVHTFkljAP/qXP/S9t239uZfLK6jUCRP25W+JJPMfejYDurKF1KJjlKMPak35hJiEbpYjCa+LDdAjrEWJgl@lists.postgresql.org X-Gm-Message-State: AOJu0YzhTbq/RyTrdb6l/G332x3ylOTRGmkOTkUP6+HqYE63sTvDsRxa Cr0oXKbtdVsOzsrULnbOCGhhL//3juLb0YQP2L5qwJxzcwk0QNxMh2oVXcewyGsEhuHBYZ7BPr3 cJuaD6wbkPGDMewDBklPUFK2Y21aHCI8= X-Gm-Gg: AZuq6aIYGqjmFZzxQ8MiCMVoZOqylTsNymL33z/SsbFQgvb1iPKYuClCFvuzWqXuK5r qurAztoxjDIdpi8LqDPG6UARKFCRuYhctZgFtg9f+SZ79f6u2bdA6DvJa/Z9Jm2PfFLjn3Um59y Ib7TNzUN25PiFdBtnZ75ewhSJAUMu2eZLMSLpOHfi5G1k3hIivD1agBDMU4qSov6qh1s4+SO43K NXa+cY/hNuJDwgibr4uFzos1IS1tM5QUMQhRGDi3FhoK7xdpY7l+TTr5ImI67LDMLSEo3gftxKZ q0brZEXWwboJsmpf7A== X-Received: by 2002:a05:690c:f09:b0:797:ab90:8cd7 with SMTP id 00721157ae682-797ab908dfemr67720957b3.51.1771233292346; Mon, 16 Feb 2026 01:14:52 -0800 (PST) MIME-Version: 1.0 References: <48261e54-c4f1-4bde-a4a9-4f3698a6b380@app.fastmail.com> In-Reply-To: From: vignesh C Date: Mon, 16 Feb 2026 14:44:41 +0530 X-Gm-Features: AaiRm53l4j8bvSICAbJPwvX3B0LKGOuXwygPuFBZZoZfCPtWtXgcwtn1duSiLWg Message-ID: Subject: Re: [Proposal] Adding Log File Capability to pg_createsubscriber To: Gyan Sreejith Cc: Amit Kapila , Euler Taveira , "kuroda.hayato@fujitsu.com" , "pgsql-hackers@lists.postgresql.org" , Peter Smith Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, 9 Feb 2026 at 07:38, Gyan Sreejith wrote: > > I was able to make the first two changes that you suggested. However, I was not able to get the test to run with one of the existing replica servers. I have attached the patch for the first two changes. For the other comment, you don't need to add a new test case, you have to choose one of the existing command_ok tests like: command_ok( [ 'pg_createsubscriber', '--verbose', '--dry-run', '--pgdata' => $node_s->data_dir, '--publisher-server' => $node_p->connstr($db1), '--socketdir' => $node_s->host, '--subscriber-port' => $node_s->port, '--replication-slot' => 'replslot1', ], 'run pg_createsubscriber without --databases'); or command_ok( [ 'pg_createsubscriber', '--verbose', '--verbose', '--recovery-timeout' => $PostgreSQL::Test::Utils::timeout_default, '--pgdata' => $node_s->data_dir, '--publisher-server' => $node_p->connstr($db1), '--socketdir' => $node_s->host, '--subscriber-port' => $node_s->port, '--publication' => 'test_pub3', '--publication' => 'pub2', '--replication-slot' => 'replslot1', '--replication-slot' => 'replslot2', '--database' => $db1, '--database' => $db2, '--enable-two-phase', '--clean' => 'publications', ], 'run pg_createsubscriber on node S'); Add --logdir' => $logdir option to this test and include the verification you are doing. Regards, Vignesh