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.
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.