Re: Questions on recovery situations (not urgent)
| От | Charles Schultz |
|---|---|
| Тема | Re: Questions on recovery situations (not urgent) |
| Дата | |
| Msg-id | CAPZQniV7AbYEFx_y8AOG81NRfE724SNCk1Pxn=0+iAyb09g77w@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Questions on recovery situations (not urgent) (Laurenz Albe <laurenz.albe@cybertec.at>) |
| Список | pgsql-admin |
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@cybertec.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.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
Charles Schultz
В списке pgsql-admin по дате отправления: