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.github@gmail.com 
>> <mailto:vijaykumarjain.github@gmail.com>> wrote:
>>
>> On Tue, 3 Aug 2021 at 20:37, Gilar Ginanjar 
>> <gilar@innovation-project.com <mailto:gilar@innovation-project.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.klaver@aklaver.com