How to extract information from Postgresql wal file?

A

Archie Kuznetsov2018-06-18 11:41:45

PostgreSQL

Archie Kuznetsov, 2018-06-18 11:41:45

There is an LSN, use it to calculate and extract wal files from the archive. you need to get the contents of these files, preferably in sql form. how to do it?

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

T

terrier, 2018-06-19
@Wolf4ara

If there was wal_level=logical
, then XLogMiner .

Similar questions

B

BonBon Slick2017-02-01 09:34:44

SQLSTATE[42883]: Undefined function: 7 ERROR: operator does not exist: integer ~~ unknown LINE 1? 1Reply

R

RobQwerty2021-02-09 12:45:00

How to organize a pattern for an online store on Laravel + PostgreSQL? 2Reply

D

Denis Sakharov2017-02-03 10:24:57

What is the correct way to do a full-text search on an incomplete match in PostgresQL? 2Reply

M

mmind2021-02-10 22:10:30

How to save emoji? 1Reply

J

Jsman2019-07-01 13:17:23

How to clear a table? 1Reply

Didn't find what you were looking for?

Ask your question