From: Laurenz Albe <laurenz.albe@cybertec.at>
To: sacrophyte@gmail.com
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Questions on recovery situations (not urgent)
Date: Tue, 11 Jun 2024 03:37:29 +0200
Message-ID: <76be6f6066f27d91e56d24238b455d339e4e3db9.camel@cybertec.at> (raw)
In-Reply-To: <CAPZQniWBL1HhtVBx9AO47aVxYvmpAnDJfwMOi+9oCGu5HX4qXQ@mail.gmail.com>
References: <CAPZQniX-EiipW_fDeVERReLky3w+kui85qSp-stHrSj_qZOAcg@mail.gmail.com>
<e903a39dc91f29d9e3eb3fb8bd50c455a21df0d6.camel@cybertec.at>
<CAPZQniWBL1HhtVBx9AO47aVxYvmpAnDJfwMOi+9oCGu5HX4qXQ@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: laurenz.albe@cybertec.at, sacrophyte@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Questions on recovery situations (not urgent)
In-Reply-To: <76be6f6066f27d91e56d24238b455d339e4e3db9.camel@cybertec.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox