Обсуждение: How to read wal files in postgresql 15?

On Fri, Jun 09, 2023 at 05:01:17PM +0300, Dennis wrote:
> How to read wal files in postgresql 15? I want to know which tables
> /objects used in wal file. Are there any tool same as logminer (Oracle) in
> postgres?

perhaps pg_waldump will help you?
https://www.postgresql.org/docs/current/pgwaldump.html

Best regards,

depesz

On Wed, Jun 14, 2023 at 11:19:44AM +0300, Dennis wrote:
>   Thanx for your answer. But I don't see any DML detail in the report. For
> example which SQL (insert update delete) is running in wal file ? Are there
> any way to see that details?

Please keep discussion to mailing list, so others can chime in, and
potentially learn from it.

if you want queries decoded from wal, you need logical decoding, like
Holger suggested.

Best regards,

depesz