Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216

Поиск
Список
Период
Сортировка
От Magnus Hagander
Тема Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216
Дата
Msg-id CABUevEz_+MKkF315yX95W_nj58AwioDOxD59PpVFYKmzb+D0mg@mail.gmail.com
обсуждение исходный текст
Ответ на archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216  (江川潔 <egawa@apteq.jp>)
Ответы Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216  (江川潔 <egawa@apteq.jp>)
Список pgsql-general
On Wed, Nov 25, 2020 at 3:02 AM 江川潔 <egawa@apteq.jp> wrote:
>
> Hi,
>
> WAL log recovery was failed on wrong log record size. Could you please advise me what is wrong in the setting ? Any
suggestionswill be highly appreciated. 
>
> Thanks,
> Kiyoshi
>
> postgres.conf:
> wal_level = replica
> archive_mode = on
> archive_command = 'copy "%p" "D:\\BKUP\\pg_archivedir\\PostgreSQL_DEV\\%f"'
>
> recover.conf:
> restore_command = 'copy "D:\\BKUP\\pg_archivedir\\PostgreSQL_DEV" "%p"'

Does your restore command really not have a %f in it anywhere? That
definitely seems wrong... But it does seem to copy some files correct,
which would be weird if it doesn't. Mistake in the report, or is there
something really weird going on with that PostgreSQL_DEV not being a
directory but instead some "magic file"?

--
 Magnus Hagander
 Me: https://www.hagander.net/
 Work: https://www.redpill-linpro.com/



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

Предыдущее
От: Michael Paquier
Дата:
Сообщение: Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Performance hit if I create multiple DBs on same instance