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 schema definitions into the database.

Then:

pg_restore -U myuser -a -t <table_name> -d mydb dbdump.backup

to restore the data for a table at a time.

You will mostly likely hit an error on one or more tables, but you will
get the rest in and know where your problem is.

>
>
>> On 5 Aug 2021, at 00.50, Vijaykumar Jain
>> <vijaykumarjain(dot)github(at)gmail(dot)com
>> <mailto:vijaykumarjain(dot)github(at)gmail(dot)com>> wrote:
>>
>> On Tue, 3 Aug 2021 at 20:37, Gilar Ginanjar
>> <gilar(at)innovation-project(dot)com <mailto:gilar(at)innovation-project(dot)com>>
>> 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 no issues yet.
>>
>>
>> Did this complete without issues ? or did it throw the same errors ?
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com