Recovering a complete database is also sometimes required. It's actually a lot easier than recovering a single table. Many users choose to place all their tables in a single database; in that case this recipe isn't relevant.
The methods differ depending upon the type of backup you have available. If you have multiple types of backup, you have a choice.
LOGICAL (from custom dump
Recreate the database into the original server using parallel tasks to speed things along. This can be executed remotely without needing to transfer dumpfile between systems like the following:
pg_restore -d myfreshdb -j 4 dumpfile
LOGICAL (from script dump created by
Recreate the database into the original ...