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 по дате отправления:

Предыдущее
От: Laurenz Albe
Дата:
Сообщение: Re: Questions on recovery situations (not urgent)
Следующее
От: SOzcn
Дата:
Сообщение: Index - Concurrently Method