Search Postgresql Archives

Re: Unexpected block ID found when reading data

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx <mailto:vijaykumarjain.github@xxxxxxxxx>> wrote:

On Tue, 3 Aug 2021 at 20:37, Gilar Ginanjar <gilar@xxxxxxxxxxxxxxxxxxxxxx <mailto:gilar@xxxxxxxxxxxxxxxxxxxxxx>> 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@xxxxxxxxxxx





[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]

  Powered by Linux