/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 vote292 views1 answer
Add mysql database to power bi web
SQL
0 vote277 views1 answer
How to fetch unique records from two tables
SQL
0 vote267 views1 answer
Can we rollback data that are deleted using DELETE
SQL
2 votes284 views1 answer
Cast string to datetime mysql
SQL
0 vote266 views1 answer
Difference between varchar and varchar2
SQL
1 vote273 views1 answer
Mysql dump specific tables
SQL
0 vote272 views1 answer
Postgresql select fast check no rows
SQL
5 votes269 views2 answers
Umgebungsvariable setzen für mysql 8
SQL
0 vote278 views1 answer
How to declare variable date in mysql
SQL
50 votes336 views4 answers
Sql alter type of column
SQL