Re: Questions on recovery situations (not urgent) - Mailing list pgsql-admin

From Laurenz Albe
Subject Re: Questions on recovery situations (not urgent)
Date
Msg-id 76be6f6066f27d91e56d24238b455d339e4e3db9.camel@cybertec.at
Whole thread Raw
In response to Re: Questions on recovery situations (not urgent)  (Charles Schultz <sacrophyte@gmail.com>)
Responses Re: Questions on recovery situations (not urgent)
List pgsql-admin
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@cybertec.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



pgsql-admin by date:

Previous
From: Charles Schultz
Date:
Subject: Re: Questions on recovery situations (not urgent)
Next
From: Charles Schultz
Date:
Subject: Re: Questions on recovery situations (not urgent)