Tenho 02 servidores um master e um slave fiz Streaming Replication tudo correu bem , coloquei no ar os dois bancos o master replicando para o slave , cheguei noutro dia a msg
FATAL: could not receive data from WAL stream: FATAL
não sei mais o que fazer voces poderiam me ajudar?
Question
Guest
waltterm2303
(usa Suse)
Bom dia
Pessoal
Tenho 02 servidores um master e um slave fiz Streaming Replication tudo correu bem , coloquei no ar os dois bancos o master replicando para o slave , cheguei noutro dia a msg
FATAL: could not receive data from WAL stream: FATAL
não sei mais o que fazer voces poderiam me ajudar?
Segue um trecho do log
MASTER
LOG: connection received: host=10.90.3.233 port=39731
LOG: replication connection authorized: user=postgres
FATAL: requested WAL segment 00000001000000050000006F has already been removed
LOG: disconnection: session time: 0:00:00.001 user=postgres database= host=10.9
0.3.233 port=39731
LOG: connection received: host=10.90.3.233 port=39732
LOG: replication connection authorized: user=postgres
FATAL: requested WAL segment 00000001000000050000006F has already been removed
LOG: disconnection: session time: 0:00:00.001 user=postgres database= host=10.9
0.3.233 port=39732
SLAVE
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 00
000001000000050000006F has already been removed
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 00
000001000000050000006F has already been removed
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 00
000001000000050000006F has already been removed
LOG: streaming replication successfully connected to primary
FATAL: could not receive data from WAL stream: FATAL: requested WAL segment 00
000001000000050000006F has already been removed
Link to comment
Share on other sites
0 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.