restore postgres database from backup command line code example Example: postgresql restore from dump psql -U postgres -h localhost -p 5432 -f data_dump.sql