Corrupt WAL in replication slot

Started by Fontana Daniel C (Desartec S.R.L.)over 3 years ago1 messagesgeneral
Jump to latest

In a replication scheme, one of the satellite databases that replicates
against a consolidated database has one of the WAL files corrupted, more
precisely the 000000010000000000000000009 file.

I try the pg_replication_slot_advance() function to move pg_lsn to skip the
error, but it tells me there is a data inconsistency. You must control the
data consistency even though I want to skip them.

As an observation, the base checkpoint is much further ahead.

Is it possible to regain control of the replication slot?

--
Este correo electrónico ha sido analizado en busca de virus por el software antivirus de Avast.
www.avast.com