/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 vote199 views1 answer
View psql output in horizontal scrolling
SQL
2 votes189 views1 answer
Mysql sql add created updated timestamp to existing table
SQL
3 votes205 views2 answers
To_char oracle
SQL
0 vote250 views1 answer
Sparql list all graphs
SQL
0 vote214 views1 answer
Sql count null values in all columns
SQL
2 votes216 views3 answers
How to check current user in mySQL
SQL
0 vote196 views1 answer
Remove default constraint sql server
SQL
0 vote216 views1 answer
Différence entre deux dates sql oracle
SQL
0 vote186 views1 answer
Check index sql server
SQL
4 votes212 views1 answer
Oracle error line
SQL