Re: Questions on recovery situations (not urgent)

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(dot)albe(at)cybertec(dot)at>
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(dot)albe(at)cybertec(dot)at>
> 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