/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

0 vote148 views1 answer
Display first three characters sql
SQL
0 vote166 views1 answer
Load data infile mariadb slow
SQL
0 vote161 views1 answer
PGSQL dynamic table name
SQL
0 vote163 views1 answer
Oracle last connexion
SQL
0 vote168 views1 answer
Find how many tables in database sql query
SQL
3 votes141 views1 answer
Oracle revoke grant
SQL
3 votes162 views1 answer
Oracle cannot access v$session
SQL
2 votes145 views2 answers
How to view created temporary tables in mysql
SQL
1 vote158 views1 answer
Blob datatype in mysql
SQL
6 votes154 views2 answers
Psql load dump
SQL