CODEWITHSUNDEEP
postgresqlwal
Tuấn Anh Nguyễn
Tuấn Anh Nguyễn

Reputation: 45

wal2json with the existing WAL (Postgres)

I have some WAL files in my current system, Do we have any solutions to use these files with wal2json? (no base backup, no archive WAL)

Upvotes: 0

Views: 522

Answers (1)

jjanes
jjanes

Reputation: 44305

Without a logical replication slot from at least that far back, it is not feasible. The catalogs must have retained enough information to reconstruct the table structures being replicated as-of the time of the WAL files it is decoding. Preserving that data is one of the things a logical replication slot does.

Upvotes: 1

Related Questions