草庐IT

PG14归档失败解决办法archiver failed on wal_lsn

案例1:pg_wal下有wal_lsn文件案例1适用于以下场景:pg_wal下有该wal_lsn文件而归档目录下无该wal_lsn文件pg_wal和归档目录下同时都有该wal_lsn文件问题描述昨晚Repmgr+PG14主备主库因wal日志撑爆磁盘,删除主库过期wal文件重做备库后上午进行主备状态巡查,主库向备库发送wal文件正常,但是查主库状态时发现显示有1条归档失败的记录。postgres:archiverfailedon000000010000006F00000086主库:walsenderrepmgr172.28.32.23(36122)streaming72/1BAC3A10"wal

PG14归档失败解决办法archiver failed on wal_lsn

问题描述昨晚Repmgr+PG14主备主库因wal日志撑爆磁盘,删除主库过期wal文件重做备库后上午进行主备状态巡查,主库向备库发送wal文件正常,但是查主库状态时发现显示有1条归档失败的记录。postgres:archiverfailedon000000010000006F00000086主库:walsenderrepmgr172.28.32.23(36122)streaming72/1BAC3A10"walsender正常archiverfailedon000000010000006F00000086"归档失败备库:walreceiverstreaming77/9EB6A198"“”“”"