]> git.immae.eu Git - github/fretlink/ansible-postgresql-role.git/commitdiff
parameters: allow wal_level customisation
authorPaul B <paul@bonaud.fr>
Mon, 11 May 2020 13:10:33 +0000 (15:10 +0200)
committerPaul B <paul@bonaud.fr>
Mon, 11 May 2020 13:11:44 +0000 (15:11 +0200)
This commit allows customisation of the `wal_level` PG config on all
supported PG versions

templates/postgresql.10.conf.j2
templates/postgresql.11.conf.j2
templates/postgresql.9.4.conf.j2
templates/postgresql.9.5.conf.j2
templates/postgresql.9.6.conf.j2

index b07b22b4ba2a78b4e9db4c8422fa74fbc289eb9b..80850348f1291348da967818747f02d06a18c505 100644 (file)
@@ -184,7 +184,7 @@ bgwriter_delay = 2000ms                     # 10-10000ms between rounds
 
 # - Settings -
 
-wal_level = logical                    # minimal, replica, or logical
+wal_level = {{ postgres_wal_level }}                   # minimal, replica, or logical
                                        # (change requires restart)
 {% if postgres_fsync_enabled %}
 #fsync = on                            # flush data to disk for crash safety
index 2c2ac1c063489aea157949a4d824017a8054435f..6acb50d6d6908a4afd79b010174c2f4c255c8e17 100644 (file)
@@ -185,7 +185,7 @@ bgwriter_delay = 2000ms                     # 10-10000ms between rounds
 
 # - Settings -
 
-wal_level = logical                    # minimal, replica, or logical
+wal_level = {{ postgres_wal_level }}                   # minimal, replica, or logical
                                        # (change requires restart)
 {% if postgres_fsync_enabled %}
 #fsync = on                            # flush data to disk for crash safety
index c251bfae9408ff508d65d6801b72f6886b1d4e43..858ae3d1b6ebaa36f193ff0f9e3a528eef4e4b74 100644 (file)
@@ -177,7 +177,7 @@ dynamic_shared_memory_type = posix  # the default is the first option
 
 # - Settings -
 
-wal_level = logical                    # minimal, archive, hot_standby, or logical
+wal_level = {{ postgres_wal_level }}                   # minimal, archive, hot_standby, or logical
                                        # (change requires restart)
 
 {% if postgres_fsync_enabled %}
index 5f666bf24c6dafbc6d3d0eae06c740b039692da2..a757382fc945a53cecfd284bb4f39f49a4c2bb39 100644 (file)
@@ -177,7 +177,7 @@ bgwriter_delay = 2000ms                     # 10-10000ms between rounds
 
 # - Settings -
 
-wal_level = logical                    # minimal, archive, hot_standby, or logical
+wal_level = {{ postgres_wal_level }}                   # minimal, archive, hot_standby, or logical
                                        # (change requires restart)
 
 {% if postgres_fsync_enabled %}
index 4c756f2a145b93d1bfd6575c700cadb6150c0744..6a726311f4dae31a65505e74cfbc2b5d5882769a 100644 (file)
@@ -185,7 +185,7 @@ bgwriter_delay = 2000ms                     # 10-10000ms between rounds
 
 # - Settings -
 
-wal_level = logical                    # minimal, replica, or logical
+wal_level = {{ postgres_wal_level }}                   # minimal, replica, or logical
                                        # (change requires restart)
 
 {% if postgres_fsync_enabled %}