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