How to restore the POSTRGESQL database in this case?

Question

PostgreSQL

Good day! The situation is this, they made a backup of the database with the pg_dump utility separately backed up WAL, the base is roughly a day old, WAL every 2 hours, until the required moment. Is it possible to somehow feed the logs to the database so that it can recover from them.

I suppose that if in the database through the pg_reseteal utility you can set the desired position for the existing logs. Is it possible or is it already to let go and forget?

Postgresql 10

PS already know what to do through pg_basebackup. Unfortunately it's too late.

Answer 1

Forget.
pg_dump has no information about the physical location of the data. There is no information in WAL about the logical location of the data - even wal_level=logical will require access to system directories. In WAL, roughly speaking, it says "write such bytes at such an offset to a file"