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. Thanks for advice. > On 3 Aug 2021, at 20.15, Vijaykumar Jain <vijaykumarjain.git...@gmail.com> > wrote: > > On Tue, 3 Aug 2021 at 08:19, Gilar Ginanjar <gi...@innovation-project.com > <mailto:gi...@innovation-project.com>> wrote: > Hi, Adrian > > Thanks in advance. > > pdgump command: > pg_dump -U myuser -Fc -Z3 -d mydb > dbdump.backup > > I'm not sure which pg_dump version did i use before, but I used psql 12.5 to > dump and the db version is postgresql 9.6. > > pgrestore command: > pg_restore -U myuser -j8 -d mydb dbdump.backup > > I’ve tried to restore to postgre 9.6, 12.1 and 12.5 > > do you remember which patch version 9.6.x did you take the dump from ? > > 9.6 has had a lot of minor fixes all the way to 9.6.22 , I am speculating, > maybe your restoration to the latest minor version is failing. > can you run a pg_restore -f <filename> ... so it creates a sql dump file and > check if that is clean ? > and then check the version in the dump file, and compile that version from > source (or git) and try if the restore worked fine there. > just saying, in case you are out of options, else ignore. >
