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