Re: Unexpected block ID found when reading data

Поиск
Список
Период
Сортировка
От Vijaykumar Jain
Тема Re: Unexpected block ID found when reading data
Дата
Msg-id CAM+6J95EhF609LYf6bEbR+go8=tSca4fTkRZv=w62x5UfdcRdg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Unexpected block ID found when reading data  (Gilar Ginanjar <gilar@innovation-project.com>)
Ответы Re: Unexpected block ID found when reading data  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Unexpected block ID found when reading data  (Gilar Ginanjar <gilar@innovation-project.com>)
Список pgsql-general
Дерево обсуждения
On Tue, 3 Aug 2021 at 08:19, Gilar Ginanjar <gilar@innovation-project.com> wrote:
Hi, Adrian

Thanks in advance.

pdgump command:
pg_dump -U myuser -Fc -Z3 -d mydb > dbdump.backup

I'm not sure which pg_dump version did i use before, but I used psql 12.5 to dump and the db version is postgresql 9.6.

pgrestore command:
pg_restore -U myuser -j8 -d mydb dbdump.backup

I’ve tried to restore to postgre 9.6, 12.1 and 12.5

do you remember which patch version 9.6.x did you take the dump from ?

9.6 has had a lot of minor fixes all the way to 9.6.22 , I am speculating, maybe your restoration to the latest minor version is failing.
can you run a pg_restore -f <filename> ... so it creates a sql dump file and check if that is clean ?
and then check the version in the dump file, and compile that version from source (or git) and try if the restore worked fine there.
just saying, in case you are out of options, else ignore.
  

В списке pgsql-general по дате отправления:

Предыдущее
От: Luca Ferrari
Дата:
Сообщение: Re: Postgres 9.6 to 12.7 pg_upgrade error - terminating connection due to administrator command
Следующее
От: Joe Conway
Дата:
Сообщение: Re: pgcrypto - real life examples to encrypt / decrypt