options to restore postgres database code example Example: restore postgres database from sql file psql -d database_name -f backup.sql