| From: | Patrick B <patrickbakerbr(at)gmail(dot)com> |
|---|---|
| To: | Melvin Davidson <melvin6925(at)gmail(dot)com> |
| Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: pg_archivecleanup - Increase time files are deleted |
| Date: | 2016-06-26 21:33:20 |
| Message-ID: | CAJNY3it6-VbSmNnTM_5a9SL86VaDvg3dscwu28Xiu9=5XunBnQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
> <https://www.postgresql.org/docs/9.4/static/runtime-config-replication.html#GUC-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
> <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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Melvin Davidson | 2016-06-26 21:42:33 | Re: pg_archivecleanup - Increase time files are deleted |
| Previous Message | Melvin Davidson | 2016-06-26 21:26:26 | Re: pg_archivecleanup - Increase time files are deleted |