Re: Unexpected block ID found when reading data

On 8/27/21 5:31 PM, Gilar Ginanjar wrote: Hi, sorry it's been a long time to reply. It throw the same errors. I can't find any solution. It frustrated me and i've been on a break since. ;) Per upstream advice do something like: pg_restore -U myuser -s -d mydb dbdump.backup to get the schem

Re: Unexpected block ID found when reading data

Hi, sorry it's been a long time to reply. It throw the same errors. I can't find any solution. It frustrated me and i've been on a break since. ;) > On 5 Aug 2021, at 00.50, Vijaykumar Jain > wrote: > > On Tue, 3 Aug 2021 at 20:37, Gilar Ginanjar > wrote

Re: Unexpected block ID found when reading data

On Tue, 3 Aug 2021 at 20:37, Gilar Ginanjar wrote: > I’m not sure which patch version i used to dump, but i was using postgre > 12.5 for pg_dump back then. > > I’m running pg_restore -f dbdump.backup right now, I think it will take > some times because it has a large size (around 9 GB). There are

Re: Unexpected block ID found when reading data

Gilar Ginanjar writes: > This is the output for "pg_restore —version”: > pg_restore (PostgreSQL) 12.7 Hmph. That's current, so it has the bug fixes that I thought might be related. Either you've hit a previously-unknown bug, or the file actually is corrupt :-(. Have you tried running the rest

Re: Unexpected block ID found when reading data

On 8/3/21 8:20 AM, Gilar Ginanjar wrote: Yes, i’ve found at some forums (DBeaver) that it is a bug on pg_restore. The specific bug being? 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 so

Re: Unexpected block ID found when reading data

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 ;

Re: Unexpected block ID found when reading data

I’m not sure which patch version i used to dump, but i was using postgre 12.5 for pg_dump back then. I’m running pg_restore -f dbdump.backup right now, I think it will take some times because it has a large size (around 9 GB). There are no issues yet. Thanks for advice. > On 3 Aug 2021, at 20

Re: Unexpected block ID found when reading data

Vijaykumar Jain writes: > On Tue, 3 Aug 2021 at 08:19, Gilar Ginanjar > 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 trie

Re: Unexpected block ID found when reading data

On Tue, 3 Aug 2021 at 08:19, Gilar Ginanjar 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. > > pgrestor

Re: Unexpected block ID found when reading data

On Tue, Aug 3, 2021 at 1:16 PM Gilar Ginanjar wrote: > Is there any small chance I can view/save/restore my data? I desperately need > it. > I guess there is not much left to do. I will try doing a pg_restore -t one table at a time to limit the damage, assuming that --section=data is not working

Re: Unexpected block ID found when reading data

Hi, Luca Thanks for the response. I’ve tried with option -L and -l before. The schema is fine, but sadly when i try to restore only data on the tables i need, it comes up with the error. Is there any small chance I can view/save/restore my data? I desperately need it. Many thanks. > On 3 Au

Re: Unexpected block ID found when reading data

On Tue, Aug 3, 2021 at 4:49 AM Gilar Ginanjar wrote: > pgrestore command: > pg_restore -U myuser -j8 -d mydb dbdump.backup > As a desparate approach I would try to use options -L and -l to extract objects from the backup and restore a small subset of them, in order to find out where the error is.

Re: Unexpected block ID found when reading data

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

Re: Unexpected block ID found when reading data

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

Re: Unexpected block ID found when reading data

On 8/2/21 6:42 PM, Gilar Ginanjar wrote: Hi, I have a db dump (.backup) that i want to restore. But it comes up with error: "found unexpected block ID when reading data" Is there any chance i can save my backup? The problem is I don't have the database anymore. I used psql 12.5 when dumping

Unexpected block ID found when reading data

Hi, I have a db dump (.backup) that i want to restore. But it comes up with error: "found unexpected block ID when reading data" Is there any chance i can save my backup? The problem is I don't have the database anymore. I used psql 12.5 when dumping the database approx a year ago.