Re: pg_archivecleanup - Increase time files are deleted
| От | Patrick B |
|---|---|
| Тема | Re: pg_archivecleanup - Increase time files are deleted |
| Дата | |
| Msg-id | CAJNY3it6-VbSmNnTM_5a9SL86VaDvg3dscwu28Xiu9=5XunBnQ@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: pg_archivecleanup - Increase time files are deleted (Melvin Davidson <melvin6925@gmail.com>) |
| Ответы |
Re: pg_archivecleanup - Increase time files are deleted
Re: pg_archivecleanup - Increase time files are deleted |
| Список | pgsql-general |
>...I'd like to have the wal_files stored for 24h, and then the pg_archivecleanup could do its job and delete the files..You cannot do that, but you can change the wal_keep_segments on the master and reload the postgresql.conf.
https://www.postgresql.org/docs/9.4/static/runtime-config-replication.html#GUC-WAL-KEEP-SEGMENTS
ok.. my current wal_keep_segments is:
wal_keep_segments = 256
That means there will be at least 256 files before postgres delete them?
Please, in the future, remember to state your PostgreSQL version and O/S as options can change.
Ok.. my mistake.. I'm running PostgreSQL 9.2 in a Centos 6.7 64 bits.
В списке pgsql-general по дате отправления: