/SQL/Postgresql backup and restore globals and data

Postgresql backup and restore globals and data

$ pg_dump -U postgres -h localhost -p 5433 --clean --file=sandbox.sql sandbox
$ pg_dumpall -U postgres -h localhost -p 5433 --clean --globals-only --file=globals.sql

Source: dba.stackexchange.com

Postgresql backup and restore globals and data

$ psql -U postgres -h localhost -p 5433 < globals.sql
$ psql -U postgres -h localhost -p 5433 < sandbox.sql

Source: dba.stackexchange.com

Similar codes

0 vote115 views2 answers
Show slave status mysql
SQL
3 votes114 views2 answers
Brew start mysql
SQL
0 vote133 views1 answer
Mysql best varchar length size
SQL
0 vote117 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote117 views1 answer
Power query datetime to date
SQL
0 vote120 views2 answers
Get all index postgres
SQL
0 vote129 views1 answer
How to know if table in rigt or left in sql
SQL
1 vote124 views1 answer
Base64 encode sql server
SQL
0 vote112 views1 answer
Mysql group rows with same value
SQL
8 votes132 views3 answers
Connect python to mysql
SQL