Re: How to recover from compressed wal archieve in windows

On 5/20/20 12:09 PM, Andrus wrote:
> 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?

Yes. Not sure how it will play with the streaming that pg_receivewal does.

Maybe the best thing is to back up a bit and let us know what it is you 
are trying to achieve?

> 
> Andrus.


-- 
Adrian Klaver
adrian.klaver@aklaver.com