restore db from dump postgres terminal code example Example: postgresql restore from dump psql -U postgres -h localhost -p 5432 -f data_dump.sql