Boa tarde à todos, gostaria de saber se posso configurar o recurso de backup "incremental" (PITR) em um servidor slave de um ambiente com o streaming replication implementado?
Em meu ambiente utilizo dois servidores PostgreSQL 9.2.2 configurados com streaming replication, estou tentando realizar o backup online a partir do servidor slave. Quando executo o comando "select pg_stop_backup();" é apresentado o seguinte erro: ERROR: recovery is in progress HINT: WAL control functions cannot be executed during recovery. Trecho do arquivo de log 2015-02-12 15:46:16 BRST [4731]: [2-1] user=[unknown],db=[unknown]LOG: incomplete startup packet 2015-02-12 15:46:16 BRST [4557]: [10-1] user=,db=LOG: restartpoint complete: wrote 813 buffers (19.8%); 0 transaction log file(s) added, 0 removed, 3 recycled; write=34.104 s, sync=0.023 s, total=34.129 s; sync files=128, longest=0.006 s, average=0.000 s 2015-02-12 15:46:16 BRST [4557]: [11-1] user=,db=LOG: recovery restart point at 1E2D/B8001820 2015-02-12 15:46:16 BRST [4557]: [12-1] user=,db=DETAIL: last completed transaction was at log time 2015-02-12 15:47:05.454553-02 2015-02-12 15:46:22 BRST [4736]: [1-1] user=[unknown],db=[unknown]LOG: connection received: host=[local] 2015-02-12 15:46:22 BRST [4736]: [2-1] user=postgres,db=postgresLOG: connection authorized: user=postgres database=postgres 2015-02-12 15:46:22 BRST [4736]: [3-1] user=postgres,db=postgresERROR: recovery is in progress 2015-02-12 15:46:22 BRST [4736]: [4-1] user=postgres,db=postgresHINT: WAL control functions cannot be executed during recovery. 2015-02-12 15:46:22 BRST [4736]: [5-1] user=postgres,db=postgresSTATEMENT: select pg_stop_backup(); 2015-02-12 15:46:22 BRST [4736]: [6-1] user=postgres,db=postgresLOG: disconnection: session time: 0:00:00.003 user=postgres database=postgres host=[local] Para montar esse teste configurei o arquivo postgresql.conf do servidor slave da seguite maneira: wal_level = archive archive_mode = on archive_command = 'cp %p /wal/%f' Obrigado a todos pela ajuda
_______________________________________________ pgbr-geral mailing list pgbr-geral@listas.postgresql.org.br https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
