pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedHow to read wal files in postgresql 15?
4+ messages / 3 participants
[nested] [flat]
* How to read wal files in postgresql 15?
@ 2023-06-09 14:01 Dennis <daslaner@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Dennis @ 2023-06-09 14:01 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi ,
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?
Thanks
Dennis
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How to read wal files in postgresql 15?
@ 2023-06-09 14:34 Holger Jakobs <holger@jakobs.com>
parent: Dennis <daslaner@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Holger Jakobs @ 2023-06-09 14:34 UTC (permalink / raw)
To: pgsql-admin@lists.postgresql.org
Hi,
Reading the WAL files directly isn't advisable. A good way to see what is going on is described here:
https://www.postgresql.org/docs/current/logicaldecoding.html
Regards
Holger
Am 9. Juni 2023 16:01:17 MESZ schrieb Dennis <daslaner@gmail.com>:
>Hi ,
>
>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?
>
>Thanks
>
>Dennis
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How to read wal files in postgresql 15?
@ 2023-06-09 15:12 hubert depesz lubaczewski <depesz@depesz.com>
parent: Dennis <daslaner@gmail.com>
1 sibling, 1 reply; 4+ messages in thread
From: hubert depesz lubaczewski @ 2023-06-09 15:12 UTC (permalink / raw)
To: Dennis <daslaner@gmail.com>; +Cc: pgsql-admin@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: How to read wal files in postgresql 15?
@ 2023-06-14 10:19 hubert depesz lubaczewski <depesz@depesz.com>
parent: hubert depesz lubaczewski <depesz@depesz.com>
0 siblings, 0 replies; 4+ messages in thread
From: hubert depesz lubaczewski @ 2023-06-14 10:19 UTC (permalink / raw)
To: Pgsql-admin <pgsql-admin@lists.postgresql.org>; +Cc: Dennis <daslaner@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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2023-06-14 10:19 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2023-06-09 14:01 How to read wal files in postgresql 15? Dennis <daslaner@gmail.com>
2023-06-09 14:34 ` Holger Jakobs <holger@jakobs.com>
2023-06-09 15:12 ` hubert depesz lubaczewski <depesz@depesz.com>
2023-06-14 10:19 ` hubert depesz lubaczewski <depesz@depesz.com>
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