Search Postgresql Archives

Corrupt WAL in replication slot

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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






[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux