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
