jnoortheen/dump-import-pg-docker.md

## dump-import-pg-docker.md

      
    Raw
  

              dump-import-pg-docker.md
            
          
    dump

docker exec -t (docker ps -q --filter name="name") pg_dumpall -U db_user -c > dump-(date +%d-%m-%Y"_"%H_%M_%S).psql
import

In case of running service, stop the services using db container

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'TARGET_DB' -- ← change this to your DB
  AND pid <> pg_backend_pid();
cat your_dump.sql | sudo docker exec -i (sudo docker ps -q --filter name="name") psql -U postgres