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

0 vote212 views1 answer
Mysql insert into select with recursive
SQL
1 vote215 views1 answer
Sql convert month name to number
SQL
1 vote244 views1 answer
Sql row having max
SQL
16 votes219 views4 answers
Mysql import from sql file
SQL
0 vote222 views1 answer
Configure MYSQL to run on another port number, other than the default port 3306 ubuntu linux
SQL
12 votes241 views4 answers
How to check mysql version ubuntu
SQL
0 vote225 views1 answer
Execut sql python
SQL
0 vote204 views1 answer
Soql update query
SQL
3 votes220 views3 answers
Restart mysql mac
SQL
5 votes228 views1 answer
How to get all dates in a month in oracle
SQL