/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 vote230 views1 answer
Rabbitmq service not starting
SQL
0 vote263 views1 answer
How to login to mysql in homestead
SQL
0 vote224 views1 answer
How to open mysql in docker
SQL
1 vote210 views1 answer
T-SQL Alter the column data type
SQL
2 votes172 views1 answer
Sql alchemy or
SQL
5 votes191 views2 answers
Mysql import gzip db
SQL
4 votes178 views1 answer
Oracle table statistics last analyzed
SQL
0 vote189 views1 answer
Postgresql delete limit
SQL
0 vote301 views1 answer
Postgres list all stored procedures query
SQL
16 votes191 views6 answers
Install sqlite3 python
SQL