I'm trying to restore a PostgreSQL backup that was created on version 11.7 on a fresh install of version 14.1.
When running the pg_restore command, it hangs on the terminal indefinitely with zero output even with verbose logging enabled. Trying to connect as a non-existing user doesn't even give an error. Connecting via psql works fine and I can execute commands without problems.
The following command was used to create the dump:
pg_dump -Fc -f file.pgdump -d mydb
I have tried restoring the dump from another host to the problematic host (one that had no problems restoring it to it's own local instance of PostgreSQL 14.1) which resulted in the same problem. This is the command I am using:
pg_restore -f file.pgdump -U user -j 6 --verbose
The fact that I am getting zero feedback from the
pg_restore command is making this rather difficult to diagnose. What could be the issue?