Postgres Pro
Downloads
Home   >   mailing lists

archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216 - Mailing list pgsql-general

From 江川潔
Subject archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216
Date
Msg-id CAH0xBbFZJ_NvWxNSfAMOnVYbVDwfMH-LOsAysABoFvPRN8EWPA@mail.gmail.com
Whole thread Raw
Responses Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216  (Michael Paquier <michael@paquier.xyz>)
Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216  (Magnus Hagander <magnus@hagander.net>)
List pgsql-general
Tree view
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>

pgsql-general by date:

Previous
From: Dave Greeko
Date:
Subject: Re: libpq Prepared Statement with dynamic IN operator
Next
From: Michael Paquier
Date:
Subject: Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216