Re: How to recover from compressed wal archieve in windows

Поиск
Список
Период
Сортировка
От Andrus
Тема Re: How to recover from compressed wal archieve in windows
Дата
Msg-id 78E8CC8DEEFB439F8930FF1980057A56@dell2
обсуждение исходный текст
Ответ на Re: How to recover from compressed wal archieve in windows  (Adrian Klaver <adrian.klaver@aklaver.com>)
Ответы Re: How to recover from compressed wal archieve in windows
Список pgsql-general
Hi!

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

How to decompress it automatically in windows ?
In Linux 

restore_command = 'gunzip < "archived_wal/%f" > "%p"'

maybe works.

Will wal_compression=on will produce compressed wal files to additional compression is not needed?

Andrus.



В списке pgsql-general по дате отправления:

Предыдущее
От: Paul Förster
Дата:
Сообщение: Re: How to recover from compressed wal archieve in windows
Следующее
От: Adam Brusselback
Дата:
Сообщение: Re: SET ROLE and search_path