I have taken the backup using pg_dumpall of Postgres 11 and currently trying to restore it to Postgres 14.1. I am using

"C:\Program Files\PostgreSQL\14\bin\pg_restore.exe" --file="DB_BKP1.dump" --verbose --host=localhost --port=5432 -U postgres to restore data but the command is stuck for an hour.

It barely has any data (just a couple of tables having a few rows in each).

I have used the following command to take the backup (and it was executed successfully without any error or warning)

"C:\Program Files\PostgreSQL\11\bin\pg_dumpall.exe" --file=DB_BKP --verbose --host=localhost --port=5433 --username=postgres

I went through the Postgres logs but didn't find anything in them.

Edit - I have over 150 different databases in my Postgres setup and to use pg_dump I would have to execute the command for each database. So, I have used pg_dumpall in place of pg_dump. Is there any drawback of using pg_dumpall that one should be aware of?