Re: How to recover from compressed wal archieve in windows

Hi!

>> 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.

I looked into WAL files created with wal_compression=on in pg_wal directory.
They still contain lot of ascii data from database which is not packed.
It looks like file WAL files content is not compressed.

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

Trying to add PITR possibility from hot standby server which uses async binary streaming replication without named slot.
Server creates 1 GB WAL files per day.
pg_receivewal with --compress=9 produces 3..5MB WAL files instead of 16MB
Trying to save disk space.
I set windows directory attribute to "compressed" in wal archieve directory. Transparent compression is then applied by OS.

However when WAL files are copied to other device, copy is perfomed probably in uncompressed form in windows.
How to set compressed attribute to pg_wal directory in Linux ext4 file system ?

Andrus.