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 1vxof2-00HAJj-1K for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 16:01:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vxof0-00DX2J-2N for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Mar 2026 16:01:19 +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.96) (envelope-from ) id 1vxof0-00DX29-1K for pgsql-hackers@lists.postgresql.org; Wed, 04 Mar 2026 16:01:18 +0000 Received: from mail-ot1-x332.google.com ([2607:f8b0:4864:20::332]) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_128_GCM_SHA256 (Exim 4.98.2) (envelope-from ) id 1vxoey-00000000Yhy-1Vat for pgsql-hackers@lists.postgresql.org; Wed, 04 Mar 2026 16:01:18 +0000 Received: by mail-ot1-x332.google.com with SMTP id 46e09a7af769-7d19d3c7208so5342203a34.0 for ; Wed, 04 Mar 2026 08:01:16 -0800 (PST) ARC-Seal: i=1; a=rsa-sha256; t=1772640074; cv=none; d=google.com; s=arc-20240605; b=PG2eSXCZ4mwLi5no4esYjfrQGcZBsLDWS3PRzn+hJVCv8cWR7PRtq7gk5tJbZP4C9l C9SmQeTJsvyd4f5ExuCSxT+YkQ/rUj2tocEScU5HGsNhh5ts+vRtb4VogsoMM3W3Psup Hhi2VS2XnfHSLmaMCyIjciBEFqKMp7eMDR5lw9gKlJ+dkSvi+PNjKhakFUbFaRnH5JoC pdAnT+HeDLZuc+/G6u0mykgiSO7JxGLkeRdgjYvDkGpM4hKk+fum6EkIp5JZlhX9tQDB Efhwpyb5f5+D90VuIhh2dbjYAYFoZW7SUeoznT3/Fmndc7rQycnWFmQe5WQoXhhxg+DG IcfA== 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=8hJOx+bgR8ezommUOx7RisZhSseoBveDhS3+NCUFtM0=; fh=E9dblTJB5Kkqi6feKRyQWkHWHqrnNQQO3JsgiWhe/oY=; b=UNPMsOA5u/gi2LUyHBCQPadJ+V97jX4rnPwLkFKtZt4eXzjU/asOMx+iyO+z1CVQEu V2zG0Hevfq4VxjDE3+il3BVEnXcQm8hfn3jBFymGSboMdFEFoVZPOSd1fL3jS2CBMyMh zvCvqGado7/Ub3GRD8rPWvFm4EDxnOFcRXUO6047/3IBE5y23nt6jMdaZnqQXJ7YcBf5 /a+BRLVFNQf8Ql1tA1X9mIQus0mgLrHPiqGAdYiOiZtA/aNyb+uzTMbizO+vh1X18xXW YgCU8tVXzPBtQ/cJM5YxV59upC2fwTfzG7HH84cT++6R6c9edVCL5X5DdwJefG7CcKR9 fKRw==; 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=1772640074; x=1773244874; 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=8hJOx+bgR8ezommUOx7RisZhSseoBveDhS3+NCUFtM0=; b=NTRe636u/b4IPkhbhVaxkuVFqtmEAlXDjYf5gyi2FqhvgdYKP+ymjekfZATXmLqi5u B0eRzphthnw7PgZt+UsxQUAeFqE7Z31GybEqqAESD8o6xOXNcOG3Qk7aYO0AA9lbBL13 6sCGY628W/LAlq02r73K5n8aBKnG5A2kvAUWaH61HYRebLtD0JsV8eR3VWgrqEDcijhW jF8AA0B2H4HETnrQvaG7Bl48Eefypoemo55yZh8XXiW/s9has1xH9enGqyshOLbY6WWS gL6k6XMO/cWfEZwg/EtT4AG0wi5Cb5ocAv641ES1Gr4cTh3ycQ/UAqf4hXxhtsr/xeSA L0PQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20230601; t=1772640074; x=1773244874; 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=8hJOx+bgR8ezommUOx7RisZhSseoBveDhS3+NCUFtM0=; b=VOlG74RoHGzkLtVfrFIQjhu/FHcZLBsPcvX1NbyyiD04ElLJsPK5Y4Qs4+XQGQcTdH JJbPLy1OzwZGv/quDyuot9OwdcOA/6J42Id+VGjJH6XC7+WS4ZV5G8N+l6Aa8wCZng0O XuCUj1aS4S3XqRhkabECqykUFM8bqtYzx5V41hScLuW4W/mGG1qea5nVe9oxxxhB3q+o v72B27ZNofn2pNeWvjvR9IK2WQ4/nTZCFH9XzkDONTP6Ud5U0jnAwjiKg2gmpwdsmGGH wEbgOuKtuxxloN7n8S87a4pHSEhztMycJTpuoYNsWlXhDGj+w9+0ESHwSfTd406Icbeo a5Og== X-Forwarded-Encrypted: i=1; AJvYcCXnQ+6nk07hIJgMhVnZiuHHujduXciwhbF7EW14NjaKMc1GVJfWXxpJ909XyrUMnMDnShRmNV1Rf/gqqSIV@lists.postgresql.org X-Gm-Message-State: AOJu0YypdRt6zfZ1V69NzVfRp+XQblaWjA8uXLFfMsEPzo66oWAxUzij eXvjrDS+8sxTAGEVymuFRC/8kjd8TRhEk45zQDvYSnyh+vzIgNVWu0YGREppkXVJ5VvH9QWBMjg x1gxro/VoYElQYiYMGjiwF9Z8CyWR4jw= X-Gm-Gg: ATEYQzxHViSoJUyH/bZuX/RW/Kc3WVuJXgq5qyXYmVXhKiIg93yn5YI0QhGK1CN2Mpq MWlzlMglptYVrSlNkdlOLP/MrvQ7DETF+1qpnC4Hr2aqOP0CRDMB8uwirvd4YqiX5U62RrEZj88 j6KOH8eAAFOkXUxeGLTHTS2EZ+z0GmnBgvrVgsGr8lE7nekHBd0IWm+F9CeY+3GrUCvn0NSneKd 550cjasqyUHzjktntuEeJfgd+joo8DCi0SRQRFNmq6kh+2Fq4RBjyIrapkh5djfNkMSTKTwwuo1 w7HK8Eg= X-Received: by 2002:a05:6830:6a16:b0:7c7:68d8:f702 with SMTP id 46e09a7af769-7d6d12580d0mr1640264a34.9.1772640073942; Wed, 04 Mar 2026 08:01:13 -0800 (PST) MIME-Version: 1.0 References: <32478450-80EC-4C55-9C80-35BEFB62060E@gmail.com> <093b33a0-6862-4b78-b778-d54e29175c7e@app.fastmail.com> In-Reply-To: <093b33a0-6862-4b78-b778-d54e29175c7e@app.fastmail.com> From: "David G. Johnston" Date: Wed, 4 Mar 2026 09:00:37 -0700 X-Gm-Features: AaiRm50AD-5lKUu-CPv3z2wDy-5_NzxB833CIPURyTdSmLNTPUD7oH8dIBrJ5oc Message-ID: Subject: Re: doc: add note that wal_level=logical doesn't set up logical replication in itself To: Euler Taveira Cc: Florents Tselai , Chao Li , Masahiko Sawada , pgsql-hackers Content-Type: multipart/alternative; boundary="000000000000ec0853064c34edc6" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --000000000000ec0853064c34edc6 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable On Wed, Mar 4, 2026 at 7:11=E2=80=AFAM Euler Taveira wr= ote: > > > > Something like: > > Note that setting this parameter only enables the required WAL format; > > it does not configure logical replication by itself. > > > > I don't think such note should be added. If the DBA doesn't know how to > setup > logical replication, it should read the Logical Replication chapter. > > Yeah, I don't think this change is directly warranted. But in trying to figure out what we can do to improve matters I find that the documentation here has some room to improve that may indeed reduce confusion and be more informative than the proposed single line addition. In particular, now that we have effective_wal_level it is unclear why people would even be here changing wal_level in the first place. The quick start guide to logical replication is at least partially at fault in that regard. Since the suggestion made here don't directly apply to the subject of this email thread, and I've some other suggestions as well, I've started a new thread here: https://www.postgresql.org/message-id/CAKFQuwY=3DWLF0OH8JE5T8S=3Daj0LBydiSn= 02fkRE73Sm_KSLRqJQ@mail.gmail.com David J. --000000000000ec0853064c34edc6 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
On Wed, Mar 4, 2026 at 7:11=E2=80=AFAM Eu= ler Taveira <eule= r@eulerto.com> wrote:
<= blockquote class=3D"gmail_quote" style=3D"margin:0px 0px 0px 0.8ex;border-l= eft:1px solid rgb(204,204,204);padding-left:1ex">>
> Something like:
> Note that setting this parameter only enables the required WAL format;=
> it does not configure logical replication by itself.
>

I don't think such note should be added. If the DBA doesn't know ho= w to setup
logical replication, it should read the Logical Replication chapter.

Yeah, I don't think this change is dire= ctly warranted.=C2=A0 But in trying to figure out what we can do to improve= matters I find that the documentation here has some room to improve that m= ay indeed reduce confusion and be more informative than the proposed single= line addition.=C2=A0 In particular, now that we have effective_wal_level i= t is unclear why people would even be here changing wal_level in the first = place.=C2=A0 The quick start guide to logical replication is at least parti= ally at fault in that regard.

Since the suggestion mad= e here don't directly apply to the subject of this email thread, and I&= #39;ve some other suggestions as well, I've started a new thread here:<= /div>


David J.

--000000000000ec0853064c34edc6--