Em qua, 26 de out de 2016 às 13:03, Cleiton Luiz Domazak < [email protected]> escreveu:
> Bom dia. > > Ativei o archive e estou utilizando o Wal-e, porém hoje percebi em um dos > servidores de teste que um range inteiro de Wal files não foram > processados, eles estão na pg_xlog, e não foram processados pelo > archive_command e nem estão na archive_status. > > Alguém tem alguma idéia do pq? > Você tem que ter algo no log. Assim "a seco", difícil. > > O ambiente é "PostgreSQL 9.4.9 x64 em CentOS 7 x64" > > postgresql.conf > > checkpoint_segments = 64 > checkpoint_completion_target = 0.9 > wal_buffers = 16MB > default_statistics_target = 100 > wal_keep_segments = 30 > max_wal_senders = 3 > wal_level = hot_standby > archive_mode = on > archive_command = 'envdir /etc/wal-e.d/env wal-e wal-push %p' > archive_timeout = 60 > > Uma parte dos arquivos gerados, o e-mail foi escrito 26/10/16 - 08:58: > > -rw------- 1 postgres postgres 16777216 Oct 26 07:45 > 000000010000011B00000027 > -rw------- 1 postgres postgres 16777216 Oct 26 07:44 > 000000010000011B00000028 > -rw------- 1 postgres postgres 16777216 Oct 26 07:46 > 000000010000011B00000029 > -rw------- 1 postgres postgres 16777216 Oct 26 07:50 > 000000010000011B0000002A > -rw------- 1 postgres postgres 16777216 Oct 26 07:51 > 000000010000011B0000002B > -rw------- 1 postgres postgres 16777216 Oct 26 07:52 > 000000010000011B0000002C > -rw------- 1 postgres postgres 16777216 Oct 26 07:53 > 000000010000011B0000002D > -rw------- 1 postgres postgres 16777216 Oct 26 07:57 > 000000010000011B0000002E > -rw------- 1 postgres postgres 16777216 Oct 26 07:54 > 000000010000011B0000002F > -rw------- 1 postgres postgres 16777216 Oct 26 07:58 > 000000010000011B00000030 > -rw------- 1 postgres postgres 16777216 Oct 26 07:55 > 000000010000011B00000031 > -rw------- 1 postgres postgres 16777216 Oct 26 07:56 > 000000010000011B00000032 > -rw------- 1 postgres postgres 16777216 Oct 26 07:59 > 000000010000011B00000033 > -rw------- 1 postgres postgres 16777216 Oct 26 08:05 > 000000010000011B00000034 > -rw------- 1 postgres postgres 16777216 Oct 26 08:04 > 000000010000011B00000035 > -rw------- 1 postgres postgres 16777216 Oct 26 08:02 > 000000010000011B00000036 > -rw------- 1 postgres postgres 16777216 Oct 26 08:03 > 000000010000011B00000037 > -rw------- 1 postgres postgres 16777216 Oct 26 08:00 > 000000010000011B00000038 > -rw------- 1 postgres postgres 16777216 Oct 26 08:01 > 000000010000011B00000039 > -rw------- 1 postgres postgres 16777216 Oct 26 08:06 > 000000010000011B0000003A > -rw------- 1 postgres postgres 16777216 Oct 26 08:07 > 000000010000011B0000003B > -rw------- 1 postgres postgres 16777216 Oct 26 08:09 > 000000010000011B0000003C > -rw------- 1 postgres postgres 16777216 Oct 26 08:08 > 000000010000011B0000003D > > > Conteúdo da archive_status: > > -rw------- 1 postgres postgres 0 Oct 25 21:23 > 00000001000001170000005C.00000028.backup.done > -rw------- 1 postgres postgres 0 Oct 26 08:25 000000010000011A000000CB.done > -rw------- 1 postgres postgres 0 Oct 26 08:26 000000010000011A000000CC.done > -rw------- 1 postgres postgres 0 Oct 26 08:27 000000010000011A000000CD.done > -rw------- 1 postgres postgres 0 Oct 26 08:28 000000010000011A000000CE.done > -rw------- 1 postgres postgres 0 Oct 26 08:29 000000010000011A000000CF.done > -rw------- 1 postgres postgres 0 Oct 26 08:30 000000010000011A000000D0.done > -rw------- 1 postgres postgres 0 Oct 26 08:31 000000010000011A000000D1.done > -rw------- 1 postgres postgres 0 Oct 26 08:32 000000010000011A000000D2.done > -rw------- 1 postgres postgres 0 Oct 26 08:33 000000010000011A000000D3.done > -rw------- 1 postgres postgres 0 Oct 26 08:34 000000010000011A000000D4.done > -rw------- 1 postgres postgres 0 Oct 26 08:35 000000010000011A000000D5.done > -rw------- 1 postgres postgres 0 Oct 26 08:36 000000010000011A000000D6.done > -rw------- 1 postgres postgres 0 Oct 26 08:37 000000010000011A000000D7.done > -rw------- 1 postgres postgres 0 Oct 26 08:38 000000010000011A000000D8.done > -rw------- 1 postgres postgres 0 Oct 26 08:39 000000010000011A000000D9.done > -rw------- 1 postgres postgres 0 Oct 26 08:40 000000010000011A000000DA.done > -rw------- 1 postgres postgres 0 Oct 26 08:41 000000010000011A000000DB.done > -rw------- 1 postgres postgres 0 Oct 26 08:42 000000010000011A000000DC.done > -rw------- 1 postgres postgres 0 Oct 26 08:43 000000010000011A000000DD.done > -rw------- 1 postgres postgres 0 Oct 26 08:44 000000010000011A000000DE.done > -rw------- 1 postgres postgres 0 Oct 26 08:45 000000010000011A000000DF.done > -rw------- 1 postgres postgres 0 Oct 26 08:46 000000010000011A000000E0.done > -rw------- 1 postgres postgres 0 Oct 26 08:47 000000010000011A000000E1.done > -rw------- 1 postgres postgres 0 Oct 26 08:48 000000010000011A000000E2.done > -rw------- 1 postgres postgres 0 Oct 26 08:49 000000010000011A000000E3.done > -rw------- 1 postgres postgres 0 Oct 26 08:50 000000010000011A000000E4.done > -rw------- 1 postgres postgres 0 Oct 26 08:51 000000010000011A000000E5.done > -rw------- 1 postgres postgres 0 Oct 26 08:52 000000010000011A000000E6.done > -rw------- 1 postgres postgres 0 Oct 26 08:53 000000010000011A000000E7.done > -rw------- 1 postgres postgres 0 Oct 26 08:54 000000010000011A000000E8.done > -rw------- 1 postgres postgres 0 Oct 26 08:55 000000010000011A000000E9.done > -rw------- 1 postgres postgres 0 Oct 26 08:56 000000010000011A000000EA.done > -rw------- 1 postgres postgres 0 Oct 26 08:57 000000010000011A000000EB.done > > > Nos logs do PostgreSQL não existe nenhuma referencia para os arquivos que > não foram processados, nem com erro do arquivamento feito pelo Wal-e. > Então ele arquivou. Você olhou no seu bucket S3 se os arquivos não estão lá? O PostgreSQL não remove imediatamente os arquivos após arquivamento, ele vai renomeá-los depois para os novos segmentos necessários. > > > Na pg_stat_archiver também não tem nenhuma referencia de erro. > > É como simplesmente esses arquivos não existissem. > O que quer dizer com "não existissem"? Eles não cairam no seu bucket? []s Flavio Gurgel
_______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
