/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 vote179 views1 answer
AddEntityFrameworkSqlite
SQL
0 vote235 views1 answer
Error Code: 1267. Illegal mix of collations (latin1_general_ci,IMPLICIT) and (latin1_swedish_ci,IMPLICIT) for operation '=' 0.000 sec
SQL
0 vote196 views1 answer
Sql on-premises
SQL
0 vote188 views1 answer
How to add more columns to a table in mysql
SQL
0 vote197 views1 answer
Mariadb maximum left join
SQL
1 vote210 views1 answer
How to set up a trigger in sql
SQL
2 votes186 views1 answer
How to search table name in stored procedure in sql server
SQL
0 vote205 views1 answer
Ajouter une clé etrangere mysql
SQL
1 vote186 views1 answer
How to find median of a column sql
SQL
1 vote208 views1 answer
Date in where on datetime column clause mysql
SQL