Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtps
 (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1ji9Yc-0001Hl-AC
	for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jun 2020 04:38:46 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <pgsql-hackers-owner+archive@lists.postgresql.org>)
	id 1ji9Ya-0007Lv-AK
	for pgsql-hackers@arkaria.postgresql.org; Mon, 08 Jun 2020 04:38:44 +0000
Received: from makus.postgresql.org ([2001:4800:3e1:1::229])
	by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256)
	(Exim 4.92)
	(envelope-from <shackle@fetter.org>)
	id 1ji9YZ-0007Ln-LT
	for pgsql-hackers@lists.postgresql.org; Mon, 08 Jun 2020 04:38:44 +0000
Received: from xvm-110-146.dc2.ghst.net ([46.226.110.146] helo=fetter.org)
	by makus.postgresql.org with esmtp (Exim 4.92)
	(envelope-from <shackle@fetter.org>)
	id 1ji9YS-0005IN-5s
	for pgsql-hackers@postgresql.org; Mon, 08 Jun 2020 04:38:42 +0000
Received: by fetter.org (Postfix, from userid 1001)
	id E7A9340DC4; Mon,  8 Jun 2020 06:38:33 +0200 (CEST)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/simple; d=fetter.org;
	s=default; t=1591591113;
	bh=j4P9AD3d9aGIhlxTqAezxxxDcqHCMA/edPBVna3P/5A=;
	h=Date:From:To:Subject:From;
	b=xabJjSRKrQ+M1054VE4AFaudYXMZUIvScfpKt7OO0nHGHNmlen3G5t3GK0Yk7VqPi
	 lXOkju87H4ktqsJTXbcGJk9IuX6OPbseWBcR0FIB0cD13Bu+99N/q+00YtG+8NwWfx
	 03LU1nmXC+oO0vWxSQdKwq+GhRkEDUKWPpnm0Yr5gflxVjKepU+wPRwcsI1iuQIJYD
	 RzA1jyi0J9yCAJIp9HsScCBLbtiJPjejFJZOhvQu8x5jKUzK/mhmEJyNmSwt8jye4I
	 pWNz5zxFxFqYD0tX51WFYPedccX5GYXenEEcNF7pv3DWDlBosn61UzYydXnvGkk935
	 OCJJCuJINW1Wg==
Date: Mon, 8 Jun 2020 06:38:33 +0200
From: David Fetter <david@fetter.org>
To: PostgreSQL Development <pgsql-hackers@postgresql.org>
Subject: Bump default wal_level to logical
Message-ID: <20200608043833.GX13741@fetter.org>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="TakKZr9L6Hm6aLOc"
Content-Disposition: inline
User-Agent: Mutt/1.9.4 (2018-02-28)
List-Id: <pgsql-hackers.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-hackers@lists.postgresql.org>
List-Owner: <mailto:pgsql-hackers-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-hackers>
Precedence: bulk


--TakKZr9L6Hm6aLOc
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline

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/donate

--TakKZr9L6Hm6aLOc
Content-Type: text/x-diff; charset=us-ascii
Content-Disposition: attachment;
 filename="v1-0001-Bump-default-wal_level-to-logical.patch"

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.sgml
index 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.c
index 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.sample
index 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--



--TakKZr9L6Hm6aLOc--