Search Postgresql Archives

Re: pg_archivecleanup - Increase time files are deleted

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Sun, Jun 26, 2016 at 5:33 PM, Patrick B <patrickbakerbr@xxxxxxxxx> wrote:


>...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. 


>That means there will be at least 256 files before postgres delete them?

Yes!
--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux