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

2020-11-25 Thread 江川潔
Hi I have corrected it on "restore_command = 'copy "D:\\BKUP\\pg_archivedir\\PostgreSQL_DEV\\%f" "%p"'". Thanks, Kiyoshi 2020年11月25日(水) 19:35 Magnus Hagander : > On Wed, Nov 25, 2020 at 3:02 AM 江川潔 wrote: > > > > Hi, > > > > WAL log recovery was failed on wrong log record size. Could you please

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

2020-11-25 Thread Magnus Hagander
On Wed, Nov 25, 2020 at 3:02 AM 江川潔 wrote: > > Hi, > > WAL log recovery was failed on wrong log record size. Could you please advise > me what is wrong in the setting ? Any suggestions will be highly appreciated. > > Thanks, > Kiyoshi > > postgres.conf: > wal_level = replica > archive_mode = on >

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

2020-11-24 Thread Michael Paquier
TAL: archive file > "000000010000006F" has wrong size: 67118648 instead of 16777216 Something is fishy with your WAL archive partition, so you had better check its state, by for example using pg_waldump on each segment archived. This error means that the file copied was basically 64MB in si

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

2020-11-24 Thread 江川潔
L_DEV\0001006F.0060.backup D:\BKUP\pg_archivedir\PostgreSQL_DEV\0001000000000070 1 個のファイルをコピーしました。 2020-11-25 10:12:23.569 JST [7792] FATAL: archive file "0001006F" has wrong size: 67118648 instead of 16777216 2020-11-25 10:12:23.571 JST [757