/SQL/Copy data from one postgres container to another

Copy data from one postgres container to another

docker exec -t your-db-container pg_dumpall -c -U postgres > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql
cat your_dump.sql | docker exec -i your-db-container psql -U postgres

Source: stackoverflow.com

Similar codes

1 vote214 views1 answer
Alter database datafile maxsize 32g
SQL
1 vote223 views3 answers
Psql fatal database does not exist
SQL
0 vote235 views1 answer
How to find date from date table in sql
SQL
0 vote213 views1 answer
Sql order by except one row
SQL
123 votes1.2K views5 answers
Sql where contains
SQL
14 votes214 views3 answers
How to add default constraint in mysql
SQL
0 vote196 views1 answer
Redudancy in SQL
SQL
0 vote196 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote208 views1 answer
How to increase the width of the screen in oracle
SQL
0 vote198 views1 answer
How to avoid duplicate records in sqlite
SQL