Re: How to recover from compressed wal archieve in windows

From: "Andrus" <kobruleht2(at)hot(dot)ee>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>, "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>
Subject: Re: How to recover from compressed wal archieve in windows
Date: 2020-05-20 19:09:14
Message-ID: 78E8CC8DEEFB439F8930FF1980057A56@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi!

>I'm guessing:
>restore_command='copy "D:\\wallog\\%f.gz" "%p"'
>will get you the file.
>The next problem is that I'm pretty sure a WAL file with *.gz extension
>will not be able to be processed directly by the server. So you are
>going to have to uncompress it at some point before it gets restored.

How to decompress it automatically in windows ?
In Linux

restore_command = 'gunzip < "archived_wal/%f" > "%p"'

maybe works.

Will wal_compression=on will produce compressed wal files to additional compression is not needed?

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adam Brusselback 2020-05-20 19:28:21 Re: SET ROLE and search_path
Previous Message Paul Förster 2020-05-20 18:43:22 Re: How to recover from compressed wal archieve in windows