Re: Questions on recovery situations (not urgent)

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: sacrophyte(at)gmail(dot)com
Cc: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: Re: Questions on recovery situations (not urgent)
Date: 2024-06-11 01:37:29
Message-ID: 76be6f6066f27d91e56d24238b455d339e4e3db9.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Charles Schultz 2024-06-11 11:22:35 Re: Questions on recovery situations (not urgent)
Previous Message Charles Schultz 2024-06-10 18:41:03 Re: Questions on recovery situations (not urgent)