Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q7dCU-0007bF-Hf for pgsql-admin@arkaria.postgresql.org; Fri, 09 Jun 2023 14:34:50 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1q7dCS-0006uh-Am for pgsql-admin@arkaria.postgresql.org; Fri, 09 Jun 2023 14:34:48 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1q7dCR-0006uX-VG for pgsql-admin@lists.postgresql.org; Fri, 09 Jun 2023 14:34:47 +0000 Received: from jakobs.com ([85.214.83.89] helo=rs.plausibolo.de) by magus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.94.2) (envelope-from ) id 1q7dCO-001Eb5-IJ for pgsql-admin@lists.postgresql.org; Fri, 09 Jun 2023 14:34:47 +0000 Received: from localhost (localhost [127.0.0.1]) by rs.plausibolo.de (Postfix) with ESMTP id 771E338047D for ; Fri, 9 Jun 2023 16:34:43 +0200 (CEST) Received: from rs.plausibolo.de ([IPv6:::1]) by localhost (h2367442.stratoserver.net [IPv6:::1]) (amavisd-new, port 10024) with ESMTP id 9Am0qw7HquIi for ; Fri, 9 Jun 2023 16:34:43 +0200 (CEST) Received: from [127.0.0.1] (dynamic-046-114-209-017.46.114.pool.telefonica.de [46.114.209.17]) by rs.plausibolo.de (Postfix) with ESMTPSA id 1A5E5380311 for ; Fri, 9 Jun 2023 16:34:43 +0200 (CEST) Date: Fri, 09 Jun 2023 16:34:35 +0200 From: Holger Jakobs To: pgsql-admin@lists.postgresql.org Subject: Re: How to read wal files in postgresql 15? User-Agent: K-9 Mail for Android In-Reply-To: References: Message-ID: <6387B7A0-05B4-4EEE-A2D8-EF83145A5885@jakobs.com> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary=----VQ6MC9TUO81E8III8BQ288W3RHZUVB Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------VQ6MC9TUO81E8III8BQ288W3RHZUVB Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable Hi,=20 Reading the WAL files directly isn't advisable=2E A good way to see what i= s going on is described here: https://www=2Epostgresql=2Eorg/docs/current/logicaldecoding=2Ehtml Regards Holger Am 9=2E Juni 2023 16:01:17 MESZ schrieb Dennis : >Hi , > >How to read wal files in postgresql 15? I want to know which tables >/objects used in wal file=2E Are there any tool same as logminer (Oracle)= in >postgres? > >Thanks > >Dennis ------VQ6MC9TUO81E8III8BQ288W3RHZUVB Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable

Hi,

Reading the WAL file= s directly isn't advisable=2E A good way to see what is going on is describ= ed here:

https://www=2Epostgresql=2Eorg/docs/current/logicaldeco= ding=2Ehtml

Regards
Holger

Am 9=2E Juni 2023 16:01:17 MESZ schrieb Dennis <= daslaner@gmail=2Ecom>:

Hi ,

How to read wal files in postgres= ql 15? I want to know which tables /objects used in wal file=2E Are there a= ny tool same as logminer (Oracle) in postgres?
Thanks

Dennis

------VQ6MC9TUO81E8III8BQ288W3RHZUVB--