| From: | Sergei Kornilov <sk(at)zsrv(dot)org> |
|---|---|
| To: | Raghavendra Rao J S V <raghavendrajsv(at)gmail(dot)com> |
| Cc: | David G(dot) Johnston <david(dot)g(dot)johnston(at)gmail(dot)com>, "pgsql-bugs(at)postgresql(dot)org" <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #14963: Number of wal files are keep on increasing |
| Date: | 2017-12-12 09:44:48 |
| Message-ID: | 1040281513071888@web2o.yandex.ru |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
Hello
Empty archive_command with archive_mode = on prohibits purge old WAL.
If you will use archive_mode - you must provide correct command in archive_command (change archive_command need only reload). Documentation can be found here: https://www.postgresql.org/docs/current/static/continuous-archiving.html#BACKUP-ARCHIVING-WAL
Otherwise you must disable archive_mode (need restart) or use archive_command with any command returning 0. For example archive_command = '/bin/true'. This is useful if you wish enable WAL archiving later without restart postgresql.
regards, Sergei
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Raghavendra Rao J S V | 2017-12-12 09:51:10 | Re: BUG #14963: Number of wal files are keep on increasing |
| Previous Message | Raghavendra Rao J S V | 2017-12-12 08:52:13 | Re: BUG #14963: Number of wal files are keep on increasing |