It turns out that we are using TDE (which I knew, but I assumed pg_waldump was decrypting - bad assumption). It took a few tries, but I finally figured out how to get pg_waldump to work with the decrypt flags.
Thanks for the feedback!
On Mon, Jun 10, 2024 at 8:37 PM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
On Mon, 2024-06-10 at 13:41 -0500, Charles Schultz wrote:
> On Wed, May 29, 2024 at 10:05 AM Laurenz Albe <laurenz.albe@xxxxxxxxxxx> wrote:
> > Did you compress the files? If yes, you have to uncompress them before feeding them
> > to "pg_waldump".
>
> We do use compression (wal_compression="on"), which looks to default to pglz.
> How might I decompress them? I tried gunzip in several iterations, but no dice.
That will compress full-page images *within* the WAL segment, but not the file
itself. The file should still have the regular size.
Perhaps your archiver truncated the file somehow.
Yours,
Laurenz Albe
Charles Schultz