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  (Melvin Davidson <melvin6925@gmail.com>)
Re: pg_archivecleanup - Increase time files are deleted  (Ian Barwick <ian@2ndquadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Melvin Davidson
Дата:
Сообщение: Re: pg_archivecleanup - Increase time files are deleted
Следующее
От: Melvin Davidson
Дата:
Сообщение: Re: pg_archivecleanup - Increase time files are deleted