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