Date: Wed, 14 Jun 2023 12:19:01 +0200
From: hubert depesz lubaczewski <depesz@depesz.com>
Sender: depesz@depesz.com
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Cc: Dennis <daslaner@gmail.com>
Subject: Re: How to read wal files in postgresql 15?
Message-ID: <ZImUFb4s2tASIVk8@depesz.com>
Reply-To: depesz@depesz.com
References: 
 <CANveA+0spDrpUKYMhs+DYH=kOAiKR=N8qyOPaUnPqLJPFLX3TA@mail.gmail.com>
 <ZINBdx5/4mxuTYJB@depesz.com>
 <CANveA+0mU8dEYnUasC6yUhmvkVCUQSAYw2qwGqqFTrFwqOh+Xg@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Disposition: inline
In-Reply-To: 
 <CANveA+0mU8dEYnUasC6yUhmvkVCUQSAYw2qwGqqFTrFwqOh+Xg@mail.gmail.com>
Archived-At: 
 <https://www.postgresql.org/message-id/ZImUFb4s2tASIVk8%40depesz.com>
Precedence: bulk

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