Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
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
-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
В списке pgsql-general по дате отправления: