| From: | 江川潔 <egawa(at)apteq(dot)jp> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216 |
| Date: | 2020-11-25 02:01:37 |
| Message-ID: | CAH0xBbFZJ_NvWxNSfAMOnVYbVDwfMH-LOsAysABoFvPRN8EWPA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Paquier | 2020-11-25 03:47:42 | Re: archive file "00000001000000000000006F" has wrong size: 67118648 instead of 16777216 |
| Previous Message | Dave Greeko | 2020-11-25 01:33:31 | Re: libpq Prepared Statement with dynamic IN operator |