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