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>
Subject: How to recover from compressed wal archieve in windows
Date: 2020-05-20 15:08:38
Message-ID: 241F4C06123741D8BA0283C8690A5F12@dell2
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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"'

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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Anders Bøgh Bruun 2020-05-20 15:16:16 Re: Logical replication troubles
Previous Message Peter Eisentraut 2020-05-20 13:00:35 Re: Logical replication troubles