Postgresql dump and restore db

Postgresql restore from dump

psql -U postgres -h localhost -p 5432 -f data_dump.sql

Postgresql dump and restore db

#To dump a database called mydb into a SQL-script file:
pg_dump mydb > db.sql

#To reload such a script into a (freshly created) database named newdb:
psql -d newdb -f db.sql

Source: stackoverflow.com

Restore postgres database from sql file

psql -d database_name -f backup.sql

Source: stackoverflow.com

Similar codes

2 votes104 views1 answer
Get first n letter of department name in sql
SQL
0 vote109 views1 answer
Remove mysql from centos 7
SQL
0 vote100 views1 answer
How to see password mysql vestacp
SQL
7 votes110 views1 answer
Buy forge mods server hosting
SQL
0 vote122 views1 answer
DATEDIFF minute postgres
SQL
0 vote103 views1 answer
Drush run sql select
SQL
1 vote102 views1 answer
Postgresql convert text to float
SQL
2 votes147 views3 answers
Xampp mysql database not starting
SQL
3 votes107 views2 answers
Having in mysql
SQL
0 vote113 views1 answer
Sql period overlap
SQL