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
