how to restore a postgresql backup code example Example: postgresql restore from dump psql -U postgres -h localhost -p 5432 -f data_dump.sql