pg_archivecleanup - Increase time files are deleted

From: Patrick B <patrickbakerbr(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: pg_archivecleanup - Increase time files are deleted
Date: 2016-06-26 21:14:17
Message-ID: CAJNY3itn2iGRXbi_kNH-safRMQTUE+oo7PSCG5+5XOVp7c9B8g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi guys,

I've got one MASTER and three SLAVES servers, running PostgreSQL 9.2.

I had a problem with one of the masters, and because the wal_files aren't
kept for a long time, I had to re-sync all the DB.
If the wal_files were being kept longer than they are now, I wouldn't have
to re-sync (pg_basebackup) all the DB.

So, I'd like to have the wal_files stored for 24h, and then the
pg_archivecleanup could do its job and delete the files....

*How can I increase that?*

These are my wal_files now: (got from a slave)

-rw------- 1 postgres postgres 16777216 Jun 26 21:04
> 00000002000013CA000000CA
> -rw------- 1 postgres postgres 16777216 Jun 26 21:05
> 00000002000013CA000000CB
> -rw------- 1 postgres postgres 16777216 Jun 26 21:05
> 00000002000013CA000000CC
> -rw------- 1 postgres postgres 16777216 Jun 26 21:06
> 00000002000013CA000000CD
> -rw------- 1 postgres postgres 16777216 Jun 26 21:07
> 00000002000013CA000000CE
> -rw------- 1 postgres postgres 16777216 Jun 26 21:08
> 00000002000013CA000000CF
> -rw------- 1 postgres postgres 16777216 Jun 26 21:09
> 00000002000013CA000000D0
> -rw------- 1 postgres postgres 16777216 Jun 26 21:09
> 00000002000013CA000000D1
> -rw------- 1 postgres postgres 16777216 Jun 26 21:10
> 00000002000013CA000000D2
> -rw------- 1 postgres postgres 16777216 Jun 26 21:10
> 00000002000013CA000000D3
> -rw------- 1 postgres postgres 16777216 Jun 26 21:11
> 00000002000013CA000000D4
> -rw------- 1 postgres postgres 16777216 Jun 26 21:12
> 00000002000013CA000000D5

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Melvin Davidson 2016-06-26 21:26:26 Re: pg_archivecleanup - Increase time files are deleted
Previous Message Charles 2016-06-24 23:07:20 Different query plans using different roles