From: | Gilar Ginanjar <gilar(at)innovation-project(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Cc: | Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com>, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Subject: | Re: Unexpected block ID found when reading data |
Date: | 2021-08-03 15:20:10 |
Message-ID: | 87BF3B40-04F5-4A25-842C-8A97ACE5D165@innovation-project.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Yes, i’ve found at some forums (DBeaver) that it is a bug on pg_restore. Hopefully so, so that I have hope to restore my data later.
This is the output for "pg_restore —version”:
pg_restore (PostgreSQL) 12.7
And this are some "pg_restore -l -v dbdump.backup” output:
; dbname: mydb
; TOC Entries: 6487
; Compression: 3
; Dump Version: 1.14-0
; Format: CUSTOM
; Integer: 4 bytes
; Offset: 8 bytes
; Dumped from database version: 9.6.21
; Dumped by pg_dump version: 12.5
Once again many thanks for the help. Really appreciate it.
> On 3 Aug 2021, at 20.59, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
> Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> writes:
>> On Tue, 3 Aug 2021 at 08:19, Gilar Ginanjar <gilar(at)innovation-project(dot)com>
>> wrote:
>>> 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
>
>> 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.
>
> This error is internal to pg_restore, so the target server version isn't
> going to make any difference. Either the dump file is corrupt, or more
> likely you're dealing with a pg_restore bug or version discrepancy.
> (pg_restore *should* complain if the archive file is too new, but there
> were some bugs in that code until recently :-(.)
>
> Anyway, people have asked for the pg_restore version several times,
> and I hope this explains why it's critical information. *PLEASE*
> show us the output of "pg_restore --version". It would also be
> useful to see the first dozen or two lines of output from
> "pg_restore -l -v dbdump.backup", which should include the dump
> file's version as well as the source pg_dump's version.
>
> regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | Adrian Klaver | 2021-08-03 15:30:54 | Re: Unexpected block ID found when reading data |
Previous Message | Gilar Ginanjar | 2021-08-03 15:06:59 | Re: Unexpected block ID found when reading data |