From: David Fetter <david@fetter.org>
To: PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Bump default wal_level to logical
Date: Mon, 8 Jun 2020 06:38:33 +0200
Message-ID: <20200608043833.GX13741@fetter.org> (raw)
Hi,
I'd like to propose $subject, as embodied in the attached patch. This
makes it possible to discover and fulfill a need for logical
replication that can arise at a time when bouncing the server has
become impractical, i.e. when there is already high demand on it.
Best,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778
Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donateAttachments:v1-0001-Bump-default-wal_level-to-logical.patch (text/x-diff, 2.9K) download
From 8179603827107d4b4ec5fe5e893b274e839a0ac1 Mon Sep 17 00:00:00 2001
From: David Fetter <david@fetter.org>
Date: Sun, 7 Jun 2020 21:31:50 -0700
Subject: [PATCH v1] Bump default wal_level to logical
To: hackers
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="------------2.26.2"
This is a multi-part message in MIME format.
--------------2.26.2
Content-Type: text/plain; charset=UTF-8; format=fixed
Content-Transfer-Encoding: 8bit
diff --git doc/src/sgml/config.sgml doc/src/sgml/config.sgmlindex aca8f73a50..08bb1d7fd7 100644--- doc/src/sgml/config.sgml+++ doc/src/sgml/config.sgml@@ -2486,14 +2486,13 @@ include_dir 'conf.d'
<listitem>
<para>
<varname>wal_level</varname> determines how much information is written to
- the WAL. The default value is <literal>replica</literal>, which writes enough- data to support WAL archiving and replication, including running- read-only queries on a standby server. <literal>minimal</literal> removes all- logging except the information required to recover from a crash or- immediate shutdown. Finally,- <literal>logical</literal> adds information necessary to support logical- decoding. Each level includes the information logged at all lower- levels. This parameter can only be set at server start.+ the WAL. The default value, <literal>logical</literal>, includes all+ information necessary to support logical decoding. <literal>replica</literal>+ writes enough data to support WAL archiving and replication, including running+ read-only queries on a standby server. Finally, <literal>minimal</literal>+ removes all logging except the information required to recover from a crash or+ immediate shutdown. Each level includes the information logged at all lower levels.+ This parameter can only be set at server start.
</para>
<para>
In <literal>minimal</literal> level, no information is logged for
diff --git src/backend/utils/misc/guc.c src/backend/utils/misc/guc.cindex 2f3e0a70e0..8d27a9c2a4 100644--- src/backend/utils/misc/guc.c+++ src/backend/utils/misc/guc.c@@ -4651,7 +4651,7 @@ static struct config_enum ConfigureNamesEnum[] =
NULL
},
&wal_level,
- WAL_LEVEL_REPLICA, wal_level_options,+ WAL_LEVEL_LOGICAL, wal_level_options,
NULL, NULL, NULL
},
diff --git src/backend/utils/misc/postgresql.conf.sample src/backend/utils/misc/postgresql.conf.sampleindex ac02bd0c00..d637133db6 100644--- src/backend/utils/misc/postgresql.conf.sample+++ src/backend/utils/misc/postgresql.conf.sample@@ -192,7 +192,7 @@
# - Settings -
-#wal_level = replica # minimal, replica, or logical+#wal_level = logical # minimal, replica, or logical
# (change requires restart)
#fsync = on # flush data to disk for crash safety
# (turning this off can cause
--------------2.26.2--
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-hackers@postgresql.org
Cc: david@fetter.org
Subject: Re: Bump default wal_level to logical
In-Reply-To: <20200608043833.GX13741@fetter.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox