Command Docker PostgreSQL

postgres.md

Dump PostgreSQL

docker exec -i your_pg_container_name /bin/bash -c "PGPASSWORD=your_pg_password pg_dump --username your_pg_username your_database_name" > /desired/path/on/your/machine/dump.sql

for example

docker exec -i 48b0930423ee /bin/bash -c "PGPASSWORD=mylocalpass pg_dump --username postgres db_test_1" > my_db_dump.sql

Restore PostgreSQL

docker exec -i your_pg_container_name /bin/bash -c "PGPASSWORD=your_pg_password psql --username your_pg_username your_database_name" < /path/on/your/machine/dump.sql

for example

docker exec -i 48b0930423ee /bin/bash -c "PGPASSWORD=mylocalpass psql --username postgres db_test_1" < my_db_dump.sql

Dump and Restore with One Command

docker exec -i pg_old_container_name /bin/bash -c "PGPASSWORD=your_pg_password pg_dump --username your_pg_username your_database_name" | docker exec -i pg_new_container_name /bin/bash -c "PGPASSWORD=your_pg_password psql --username your_pg_username your_database_name"