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 > On 3 Aug 2021, at 09.11, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote: > > 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 the database approx a year ago. > > What command and version of pg_dump did you use to dump it? > > What command and program(and version) did you use to restore it? > > What version of Postgres where you restoring to? > > > -- > Adrian Klaver > adrian.klaver@xxxxxxxxxxx
