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 votes190 views1 answer
Oracle kill job by sid
SQL
4 votes184 views1 answer
Mysql set max connections
SQL
1 vote169 views2 answers
T-sql random number for each row
SQL
4 votes173 views1 answer
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.s
SQL
1 vote166 views10 answers
Stack overflow
SQL
6 votes185 views2 answers
Difference between join vs union
SQL
6 votes235 views3 answers
What is where in sql
SQL
0 vote179 views1 answer
Sql server select value large text
SQL
0 vote179 views1 answer
Sql fetch next 10 rows pdo
SQL
1 vote190 views3 answers
Connect to mysql c# connection string C#
SQL