From: | Gilar Ginanjar <gilar(at)innovation-project(dot)com> |
---|---|
To: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Unexpected block ID found when reading data |
Date: | 2021-08-03 02:48:59 |
Message-ID: | B236F738-E318-4530-8443-36F3A692CE35@innovation-project.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(dot)klaver(at)aklaver(dot)com> 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(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Gilar Ginanjar | 2021-08-03 05:28:42 | Re: Unexpected block ID found when reading data |
Previous Message | Adrian Klaver | 2021-08-03 02:11:33 | Re: Unexpected block ID found when reading data |