Backup and Restore all databases in PostgreSQL

Back up all databases in PostgreSQL using pg_dumpall utility.

pg_dumpall -f [alldatabasebackup.sql]

Example:
C:\Program Files\PostgreSQL\15\bin>pg_dumpall -U postgres -f C:\testwork\alldatabase.sql
Password:
Password:
Password:
Password:
Password:

C:\Program Files\PostgreSQL\15\bin>

Restore the database in PostgreSQL using psql utility:

psql -f alldatabasebackup.sql