On Tue, 3 Aug 2021 at 08:19, Gilar Ginanjar <gilar@xxxxxxxxxxxxxxxxxxxxxx> 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.
