Re: How to recover from compressed wal archieve in windows

On 5/20/20 8:08 AM, Andrus wrote:
> In windows 10
> pg_receivewal --directory="d:\wallog" --verbose --compress=9
> 
> is used to archieve WAL.
> 
> This creates .gz files
> 
> For restore
> 
> restore_command='copy "D:\\wallog\\%f" "%p"'

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.


> is used.
> Restore shows "file not found" errors in console. Thi sis probably 
> because %f argument is WAL file name without extension.
> How to use compressed WAL files for WAL archieve and restore in windows ?
> 
> Andrus.
> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com