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(dot)klaver(at)aklaver(dot)com