From: hubert depesz lubaczewski <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?
Date: Wed, 14 Jun 2023 12:19:01 +0200
Message-ID: <ZImUFb4s2tASIVk8@depesz.com> (raw)
In-Reply-To: <CANveA+0mU8dEYnUasC6yUhmvkVCUQSAYw2qwGqqFTrFwqOh+Xg@mail.gmail.com>
References: <CANveA+0spDrpUKYMhs+DYH=kOAiKR=N8qyOPaUnPqLJPFLX3TA@mail.gmail.com>
<ZINBdx5/4mxuTYJB@depesz.com>
<CANveA+0mU8dEYnUasC6yUhmvkVCUQSAYw2qwGqqFTrFwqOh+Xg@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: depesz@depesz.com, pgsql-admin@lists.postgresql.org, daslaner@gmail.com
Subject: Re: How to read wal files in postgresql 15?
In-Reply-To: <ZImUFb4s2tASIVk8@depesz.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox