Бэкап Postgres из Docker

DjinNFebruary 01, 2019

docker exec -u <your_postgres_user> <postgres_container_name> pg_dump -Fc <database_name_here> > db.dump

Пример Бэкапа AWX:

docker exec -u awx postgres pg_dump -Fc awx > `date +%m.%d.%y_%H.%M.%S`_awx_db.dump

docker stop

awx_taskdocker

stop awx_webdocker

stop memcached

rename current db:docker exec -u postgres postgres psql postgres awx -c 'ALTER DATABASE "awx" RENAME TO "awx_01_03_18"'

restore AWX db:docker exec -i -u postgres postgres pg_restore -C -d postgres < 01.03.18_03.17.33_awx_db.dump

docker start memcacheddocker start awx_webdocker start awx_task

if you are happy with everything you can drop your other database:docker exec -u postgres postgres psql -c 'DROP DATABASE awx_01_03_18'

Report content on this page

Report Page