/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

2 votes297 views1 answer
Sql as
SQL
3 votes287 views2 answers
Oracle grants
SQL
0 vote288 views2 answers
How to tun mysql on ubunto
SQL
3 votes275 views3 answers
Into in sql
SQL
0 vote294 views1 answer
Test the postgresql db connection
SQL
10 votes279 views2 answers
Sql rtrim
SQL
5 votes338 views2 answers
How to ascending order in sql
SQL
1 vote276 views1 answer
Oracle lock user
SQL
0 vote353 views1 answer
ORA-32794: cannot drop a system-generated sequence
SQL
0 vote298 views1 answer
How to reset the database value in SQL server
SQL