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

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 <magnus(at)hagander(dot)net>:

> On Wed, Nov 25, 2020 at 3:02 AM 江川潔 <egawa(at)apteq(dot)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 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"'
>
> 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/
>