diff options
| author | Théophile Helleboid - chtitux <chtitux@gmail.com> | 2020-06-05 13:40:43 +0400 |
|---|---|---|
| committer | GitHub <noreply@github.com> | 2020-06-05 13:40:43 +0400 |
| commit | 9e6f9658fbf5db657a2dd8465bf0ae4f41da161e (patch) | |
| tree | 0e7e023c1b7f580db314c78bf3b65b70563efcc7 /templates/postgresql.12.conf.j2 | |
| parent | ebe451adda84672f9872187164df279dbfed7a35 (diff) | |
| parent | 587f87bbf278a80b14a182146724a9ebf1fd98a2 (diff) | |
| download | ansible-postgresql-role-9e6f9658fbf5db657a2dd8465bf0ae4f41da161e.tar.gz ansible-postgresql-role-9e6f9658fbf5db657a2dd8465bf0ae4f41da161e.tar.zst ansible-postgresql-role-9e6f9658fbf5db657a2dd8465bf0ae4f41da161e.zip | |
Merge pull request #13 from paulRbr/optional-restore-command
recovery: optional restore_command & allow custom command if needed
Diffstat (limited to 'templates/postgresql.12.conf.j2')
| -rw-r--r-- | templates/postgresql.12.conf.j2 | 12 |
1 files changed, 5 insertions, 7 deletions
diff --git a/templates/postgresql.12.conf.j2 b/templates/postgresql.12.conf.j2 index b49b836..3598319 100644 --- a/templates/postgresql.12.conf.j2 +++ b/templates/postgresql.12.conf.j2 | |||
| @@ -260,20 +260,18 @@ archive_command = '' | |||
| 260 | 260 | ||
| 261 | # These are only used in recovery mode. | 261 | # These are only used in recovery mode. |
| 262 | 262 | ||
| 263 | {% if postgres_primary %} | ||
| 264 | {# In PG < 12 versions all the recovery settings were in a separate recovery.conf file #} | 263 | {# In PG < 12 versions all the recovery settings were in a separate recovery.conf file #} |
| 265 | restore_command = '/usr/bin/barman-wal-restore --user barman --parallel 8 {{ postgres_barman_server }} {{ postgres_primary.restore_directory }} %f %p' # command to use to restore an archived logfile segment | 264 | {% if postgres_primary and postgres_primary.restore_command is defined %} |
| 266 | # placeholders: %p = path of file to restore | 265 | restore_command = '{{ postgres_primary.restore_command }}' # command to use to restore an archived logfile segment |
| 267 | # %f = file name only | 266 | {% elif postgres_primary and postgres_primary.restore_barman_directory is defined %} |
| 268 | # e.g. 'cp /mnt/server/archivedir/%f %p' | 267 | restore_command = '/usr/bin/barman-wal-restore --user barman --parallel 8 {{ postgres_barman_server }} {{ postgres_primary.restore_barman_directory }} %f %p' # command to use to restore an archived logfile segment |
| 269 | # (change requires restart) | ||
| 270 | {% else %} | 268 | {% else %} |
| 271 | #restore_command = '' # command to use to restore an archived logfile segment | 269 | #restore_command = '' # command to use to restore an archived logfile segment |
| 270 | {% endif %} | ||
| 272 | # placeholders: %p = path of file to restore | 271 | # placeholders: %p = path of file to restore |
| 273 | # %f = file name only | 272 | # %f = file name only |
| 274 | # e.g. 'cp /mnt/server/archivedir/%f %p' | 273 | # e.g. 'cp /mnt/server/archivedir/%f %p' |
| 275 | # (change requires restart) | 274 | # (change requires restart) |
| 276 | {% endif %} | ||
| 277 | #archive_cleanup_command = '' # command to execute at every restartpoint | 275 | #archive_cleanup_command = '' # command to execute at every restartpoint |
| 278 | #recovery_end_command = '' # command to execute at completion of recovery | 276 | #recovery_end_command = '' # command to execute at completion of recovery |
| 279 | 277 | ||