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 <mailt
Aug 2021, at 20.59, Tom Lane wrote:
>
> 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.
>&
at 20.15, Vijaykumar Jain
> wrote:
>
> On Tue, 3 Aug 2021 at 08:19, Gilar Ginanjar <mailto:gi...@innovation-project.com>> wrote:
> Hi, Adrian
>
> Thanks in advance.
>
> pdgump command:
> pg_dump -U myuser -Fc -Z3 -d mydb > dbdump.backup
>
> I'm
n 3 Aug 2021, at 17.06, Luca Ferrari wrote:
>
> 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 obje
ve tried to restore to postgre 9.6, 12.1 and 12.5
> On 3 Aug 2021, at 09.11, Adrian Klaver 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 unexpect
ve tried to restore to postgre 9.6, 12.1 and 12.5
> On 3 Aug 2021, at 09.11, Adrian Klaver 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 unexpect
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.
