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: | Raw Message | Whole Thread | 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 |