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 1w2NZA-000EkO-1U for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Mar 2026 06:06:08 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1w2NZ9-00GQfJ-1K for pgsql-hackers@arkaria.postgresql.org; Tue, 17 Mar 2026 06:06:07 +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 1w2NZ9-00GQf7-0S for pgsql-hackers@lists.postgresql.org; Tue, 17 Mar 2026 06:06:07 +0000 Received: from mail-pf1-x431.google.com ([2607:f8b0:4864:20::431]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1w2NZ5-000000008iW-3YcA for pgsql-hackers@lists.postgresql.org; Tue, 17 Mar 2026 06:06:06 +0000 Received: by mail-pf1-x431.google.com with SMTP id d2e1a72fcca58-829afe24fb5so4269740b3a.0 for ; Mon, 16 Mar 2026 23:06:05 -0700 (PDT) ARC-Seal: i=1; a=rsa-sha256; t=1773727564; cv=none; d=google.com; s=arc-20240605; b=TmJZ4SYWgdeRBHuEbbMi9cZHUunwrGkXnyL3RCHKInha1Yu6PgIVz+u2y2a8VjXCio LRpOPfoPYjCQP74CZwOvzWZZH/rZcYzuxFMgGa1eiwDkfoEBlzVv89EXeg1SbOpDY5w2 ddymSQLFonmNmwPyl4cspyWkSSrosjndWgRS1jl6PEGeDMCwzx10e4P8ZK8JbW+bRNv6 aWgka09ultfRWyvP8z2oXFRPHybM2QbQ8iskEWkJlGSZ7aewrMkLUi3uW/VHT1VrQUI7 iSU+QRKaU3b1ibEtY7UqIMOIN1Yd5G191jAp0xDiY/GU2c4EAGg1boNzWzgRUE5nNxiT RLQw== ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=google.com; s=arc-20240605; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:dkim-signature; bh=R9XNyKVchoqZ//fb+GTeUHy4Jx/OL55ElycZ1tSYOps=; fh=sV2ikfQ7p7L+/y8ZlqmOf3413AxW6/o4D/+qIjWoO7I=; b=UfjEXESR2VNd3YdkupJAW6ZiQxKl79ykLFcNTLOY6fTy5LCFa2lbgXWhtgW2wF7ezW BFJ43RRaiodQw7kDcQT1Re5O0AtUhVuMh2cik9Spwd9DTzZWp1Df2/dCiZfZHsN6InOs O5CIv2fHKLJTnlt74ub+mOpoH6iWOtbhCJOoA91/wE53uuu8sqL4CqnBoRpAU0hdn2NP 3yYD9y5sn/Jw/TVzXY06a6m9HBa0FKlOCpvSTYB4mr+eAn9qfQ+qTNONH8+BvDA1g2JI ItCqopdTjTXv9RdQd76/6LOT+Apdq8TrR1KHf2qhb2QIevqLARotKpW9whfxPnof1oE7 z0zw==; 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=1773727564; x=1774332364; darn=lists.postgresql.org; h=content-transfer-encoding:cc:to:subject:message-id:date:from :in-reply-to:references:mime-version:from:to:cc:subject:date :message-id:reply-to; bh=R9XNyKVchoqZ//fb+GTeUHy4Jx/OL55ElycZ1tSYOps=; b=EzGfWUxdaG5hdT+EZ/de5OxF2Gh5I0gVevxpE0ihhOMD6vw8VowYP8EgiraOYAbqr1 hmiDgBUQXHoro7hcsfrOJm5vN0eS/AREgU7390svwoVMTB/cwaAbQ5Pcly74PeJEqLwo ztUqWzhkPdM6bW90TEK7hoN6RGa3dgieDOn8Fjcwxh9naaEEtO78zfx+2/u++cO/IGBx A0yUDnXxDSy/wEKn4O6Sm9Aq0tnfiPAVFuA9NEJ4qEaJV27vAA1QgT/39D5gVzX8CPz5 ly6543jCYCqHvOFl3iwahrUd2c3XG+EkmClkv4tIAvalQizA+KVd63zL4gkV3Rkc2bRf ceUw== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20251104; t=1773727564; x=1774332364; h=content-transfer-encoding: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=R9XNyKVchoqZ//fb+GTeUHy4Jx/OL55ElycZ1tSYOps=; b=kj4ocg9vvx4inyeK4JaAhpICImd9g0YnSMzQy582jxDhnbZlN+9DTuL+Q2bPBiiWpI s9Jwsx4VvN12o2R6jgXaJd0Lf+5kkp9GxqsoUNSOr1Hb2GWuKPXYhkrWrt4wCgt8k2id w121/EYidsHuhv4xlUW3lXgw3TNloATjtmF0y17qxEI7ZYn4+V9OKyaFCg0CAavylWmU DLYcdbZBDtdL2HbLUnAipgs2WVI502FFmYAAUBIrJwtcbZHMpSEWw16aP/46TMJ3k5aY Ocb+ZIsKjoXV6c1QQQbBbyLOXydzLgBd0+jacGf8SulMOkfKUJkv43xU25vEjr8LSYth 6Vug== X-Forwarded-Encrypted: i=1; AJvYcCUXzALt4XpmXUGJSWvd5ApnnjwlK9pCYMxXFV4MwE/H0MQEP7qFr4pdm5zmcm+KyqwzYf8tL06YBFpsZlsy@lists.postgresql.org X-Gm-Message-State: AOJu0YwzKFVoyqdcBGUoFbDrMVf9rH5HWFntpvj9+X4CRmE9YrazFkDz I3kZpuENzUNI886UOBv0m4FsUjr1W28jcfI/yHw07q9pvaWn1N0enuWHT3XC4ToF+8TkZVw0gjT yvwLKxNx2lRBWVlZq17pREm9n5PoI1dM= X-Gm-Gg: ATEYQzwgFQ+TuCvYHcahwpY4nfVYt0GJxdvMcFN/BHMA4qoT5lZxTIQlgZE4SqygLZ8 THHK0+L1WCbAPdVIQPVgQdbsQwYLpRR0jl1Y83cDiAAo4XxYmznl+4FwiiLF/jbp4lIvAJlMzBM xfLbeNwSlGunluqs8U6q2Pyo0oWWX+duZ6zAxxw6zDDu5IVjbQKC0MGrXZMU2k/tJVOkZtM7JJq Fo+/7w6VHGlsNgvYTCfomyqR6zPu/haxjf0GcawoS7FFtse5c0peeWkYbkbbzMKoYABxWkscQFX WFTFnNmujRzDr+TCCpwjxmk6oRUBD2Rf3Rj6SwTuqcvhCWzWaScw8g== X-Received: by 2002:a05:6a00:2d0b:b0:829:7553:afbe with SMTP id d2e1a72fcca58-82a19952539mr14348708b3a.57.1773727564505; Mon, 16 Mar 2026 23:06:04 -0700 (PDT) MIME-Version: 1.0 References: <48261e54-c4f1-4bde-a4a9-4f3698a6b380@app.fastmail.com> In-Reply-To: From: shveta malik Date: Tue, 17 Mar 2026 11:35:53 +0530 X-Gm-Features: AaiRm50qEoK0OLjTMqz27qle-GgLpB65ZHGINUgubbNjWvI7FfOeWckArtCCl70 Message-ID: Subject: Re: [Proposal] Adding Log File Capability to pg_createsubscriber To: Gyan Sreejith Cc: vignesh C , Amit Kapila , Euler Taveira , "kuroda.hayato@fujitsu.com" , "pgsql-hackers@lists.postgresql.org" , Peter Smith , shveta malik Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Mon, Mar 16, 2026 at 4:53=E2=80=AFAM Gyan Sreejith wrote: > > > Thank you! I have attached the changes. Thank You for the patch. 1) I observed that when we give both --verbose and --logdir options, it skips verbose and only dumps logs to logdir. Is this intentional? I don't see any other postgres command with both the options provided and thus cannot compare the behaviour. But IMO, if the user has explicitly given both options, we should dump the log on both (stdout and logfile). Thoughts? (Apologies if this has already been discussed and I missed it.) 2) I noticed a minor difference when running the command with both --verbose and --logdir, depending on the order in which they are specified. If --verbose is specified first, I see the following message on the console= : pg_createsubscriber: directory ../../pg_createsub/20260317T112204.848 creat= ed But if --logdir is specified first, this message does not appear on the console. Is this behavior intentional? thanks Shveta