In order to recover a full backup generated by pg_dumpall, you need to execute the following steps on a PostgreSQL server that has just been initialized:
- Confirm that you have the correct backup before you restore. If the following command returns nothing, then it means the file is not timestamped, and you'll have to identify it in a different way:
head myscriptdump.sql | grep Started
- Reload the script in full:
psql -f myscriptdump.sql