diff options
| author | Paul B <paul@bonaud.fr> | 2020-05-11 15:10:33 +0200 |
|---|---|---|
| committer | Paul B <paul@bonaud.fr> | 2020-05-11 15:11:44 +0200 |
| commit | 3a76f4474de3eb520efdfe4b41918bce2d9576ff (patch) | |
| tree | 41477a880ca169ade9b31245e6192d4e3a7ee838 | |
| parent | 0415357ede1fc2f2e1ebd543a96551fcd8a046fe (diff) | |
| download | ansible-postgresql-role-3a76f4474de3eb520efdfe4b41918bce2d9576ff.tar.gz ansible-postgresql-role-3a76f4474de3eb520efdfe4b41918bce2d9576ff.tar.zst ansible-postgresql-role-3a76f4474de3eb520efdfe4b41918bce2d9576ff.zip | |
parameters: allow wal_level customisation
This commit allows customisation of the `wal_level` PG config on all
supported PG versions
| -rw-r--r-- | templates/postgresql.10.conf.j2 | 2 | ||||
| -rw-r--r-- | templates/postgresql.11.conf.j2 | 2 | ||||
| -rw-r--r-- | templates/postgresql.9.4.conf.j2 | 2 | ||||
| -rw-r--r-- | templates/postgresql.9.5.conf.j2 | 2 | ||||
| -rw-r--r-- | templates/postgresql.9.6.conf.j2 | 2 |
5 files changed, 5 insertions, 5 deletions
diff --git a/templates/postgresql.10.conf.j2 b/templates/postgresql.10.conf.j2 index b07b22b..8085034 100644 --- a/templates/postgresql.10.conf.j2 +++ b/templates/postgresql.10.conf.j2 | |||
| @@ -184,7 +184,7 @@ bgwriter_delay = 2000ms # 10-10000ms between rounds | |||
| 184 | 184 | ||
| 185 | # - Settings - | 185 | # - Settings - |
| 186 | 186 | ||
| 187 | wal_level = logical # minimal, replica, or logical | 187 | wal_level = {{ postgres_wal_level }} # minimal, replica, or logical |
| 188 | # (change requires restart) | 188 | # (change requires restart) |
| 189 | {% if postgres_fsync_enabled %} | 189 | {% if postgres_fsync_enabled %} |
| 190 | #fsync = on # flush data to disk for crash safety | 190 | #fsync = on # flush data to disk for crash safety |
diff --git a/templates/postgresql.11.conf.j2 b/templates/postgresql.11.conf.j2 index 2c2ac1c..6acb50d 100644 --- a/templates/postgresql.11.conf.j2 +++ b/templates/postgresql.11.conf.j2 | |||
| @@ -185,7 +185,7 @@ bgwriter_delay = 2000ms # 10-10000ms between rounds | |||
| 185 | 185 | ||
| 186 | # - Settings - | 186 | # - Settings - |
| 187 | 187 | ||
| 188 | wal_level = logical # minimal, replica, or logical | 188 | wal_level = {{ postgres_wal_level }} # minimal, replica, or logical |
| 189 | # (change requires restart) | 189 | # (change requires restart) |
| 190 | {% if postgres_fsync_enabled %} | 190 | {% if postgres_fsync_enabled %} |
| 191 | #fsync = on # flush data to disk for crash safety | 191 | #fsync = on # flush data to disk for crash safety |
diff --git a/templates/postgresql.9.4.conf.j2 b/templates/postgresql.9.4.conf.j2 index c251bfa..858ae3d 100644 --- a/templates/postgresql.9.4.conf.j2 +++ b/templates/postgresql.9.4.conf.j2 | |||
| @@ -177,7 +177,7 @@ dynamic_shared_memory_type = posix # the default is the first option | |||
| 177 | 177 | ||
| 178 | # - Settings - | 178 | # - Settings - |
| 179 | 179 | ||
| 180 | wal_level = logical # minimal, archive, hot_standby, or logical | 180 | wal_level = {{ postgres_wal_level }} # minimal, archive, hot_standby, or logical |
| 181 | # (change requires restart) | 181 | # (change requires restart) |
| 182 | 182 | ||
| 183 | {% if postgres_fsync_enabled %} | 183 | {% if postgres_fsync_enabled %} |
diff --git a/templates/postgresql.9.5.conf.j2 b/templates/postgresql.9.5.conf.j2 index 5f666bf..a757382 100644 --- a/templates/postgresql.9.5.conf.j2 +++ b/templates/postgresql.9.5.conf.j2 | |||
| @@ -177,7 +177,7 @@ bgwriter_delay = 2000ms # 10-10000ms between rounds | |||
| 177 | 177 | ||
| 178 | # - Settings - | 178 | # - Settings - |
| 179 | 179 | ||
| 180 | wal_level = logical # minimal, archive, hot_standby, or logical | 180 | wal_level = {{ postgres_wal_level }} # minimal, archive, hot_standby, or logical |
| 181 | # (change requires restart) | 181 | # (change requires restart) |
| 182 | 182 | ||
| 183 | {% if postgres_fsync_enabled %} | 183 | {% if postgres_fsync_enabled %} |
diff --git a/templates/postgresql.9.6.conf.j2 b/templates/postgresql.9.6.conf.j2 index 4c756f2..6a72631 100644 --- a/templates/postgresql.9.6.conf.j2 +++ b/templates/postgresql.9.6.conf.j2 | |||
| @@ -185,7 +185,7 @@ bgwriter_delay = 2000ms # 10-10000ms between rounds | |||
| 185 | 185 | ||
| 186 | # - Settings - | 186 | # - Settings - |
| 187 | 187 | ||
| 188 | wal_level = logical # minimal, replica, or logical | 188 | wal_level = {{ postgres_wal_level }} # minimal, replica, or logical |
| 189 | # (change requires restart) | 189 | # (change requires restart) |
| 190 | 190 | ||
| 191 | {% if postgres_fsync_enabled %} | 191 | {% if postgres_fsync_enabled %} |