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

[江川潔 <egawa@xxxxxxxx>]

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

archive_command = 'copy "%p" "D:\\BKUP\\pg_archivedir\\PostgreSQL_DEV\\%f"'

recover.conf:

restore_command = 'copy "D:\\BKUP\\pg_archivedir\\PostgreSQL_DEV" "%p"'

C:\Users\tkgsys>pg_ctl -D D:\PostgreSQL_RCV start
サーバの起動完了を待っています....2020-11-25 10:12:22.330 JST [7572] LOG:  listening on IPv6 address "::", port 5434
2020-11-25 10:12:22.331 JST [7572] LOG:  listening on IPv4 address "0.0.0.0", port 5434
2020-11-25 10:12:22.393 JST [7792] LOG:  database system was interrupted; last known up at 2020-11-24 11:01:00 JST
2020-11-25 10:12:22.858 JST [7792] LOG:  starting archive recovery
D:\BKUP\pg_archivedir\PostgreSQL_DEV\000000010000000000000056.00000028.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000005A.00000028.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000005D.00000028.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\000000010000000000000060.00000060.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\000000010000000000000064.00000060.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\000000010000000000000068.00000028.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006B
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006B.00000060.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006C
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006D
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006E
.D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006F
D:\BKUP\pg_archivedir\PostgreSQL_DEV\00000001000000000000006F.00000060.backup
D:\BKUP\pg_archivedir\PostgreSQL_DEV\000000010000000000000070
        1 個のファイルをコピーしました。
2020-11-25 10:12:23.569 JST [7792] FATAL:  archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216
2020-11-25 10:12:23.571 JST [7572] LOG:  startup process (PID 7792) exited with exit code 1
2020-11-25 10:12:23.572 JST [7572] LOG:  aborting startup due to startup process failure
2020-11-25 10:12:23.576 JST [7572] LOG:  database system is shut down
 待機処理が停止されました
pg_ctl: サーバを起動できませんでした。
ログ出力を確認してください。

C:\Users\tkgsys>