Skip to content

Instantly share code, notes, and snippets.

@Eduard-gan

Eduard-gan/gist:1516f26e2a740dfc868abea4a759327b

Created April 1, 2021 09:07
Show Gist options
  • Save Eduard-gan/1516f26e2a740dfc868abea4a759327b to your computer and use it in GitHub Desktop.
Save Eduard-gan/1516f26e2a740dfc868abea4a759327b to your computer and use it in GitHub Desktop.
Download ZIP
Docker DB backup
Raw
gistfile1.txt
pg_dump -U postgres -Fc mfo > mfo.sql
docker cp postgres:/mfo.sql mfo.sql
docker cp mfo.sql postgres:/mfo.sql
SELECT pg_terminate_backend(pg_stat_activity.pid) FROM pg_stat_activity WHERE pg_stat_activity.datname = 'mfo' AND pid <> pg_backend_pid();
drop database mfo;
create database mfo;
pg_restore -U postgres -d mfo --clean --create mfo.sql
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment