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