/SQL/Restore postgres database from sql file

Restore postgres database from sql file

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 vote250 views1 answer
Ms sql print more than 1 variable
SQL
1 vote303 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
0 vote246 views1 answer
How to connect sql server using ip address in c#
SQL
0 vote298 views1 answer
What is default mysql database password in linux
SQL
0 vote317 views1 answer
Set Mamp mysql globally
SQL
0 vote328 views1 answer
Sql server for loop
SQL
0 vote289 views1 answer
How to import sqlite driver class in java using maven
SQL
0 vote300 views1 answer
Oracle date summer time
SQL
1 vote324 views1 answer
Mysql curdate between two dates
SQL
0 vote339 views1 answer
Cube oracle
SQL