Home / server / Questions / 644740
In Process
Peter Lyons
Asked: 2014-11-17 07:17:00 +0800 CST

backup postgresql via docker exec

  • 772

How would you go about taking automatic rotated backups of a postgresql database running inside a docker 1.3 container? I'm mostly interested in the overall approach vs. the details of actual the backup commands themselves.

I am thinking about updating this autobackup script, which has apparently been around since 2005. My current plan is

  • Install the script in cron.daily on the docker host
  • Have the script use direct local filesystem access for the rotation logic to handle the existence tests, mkdir and rm commands
  • use docker exec containername to run the psql and pg_dump commands within the container, probably sending the stdout content to the docker host filesystem in the correct place via shell redirection
postgresql

1 Answers

  1. The autobackup script is nice but don't verget to make a backup of the users and passwords: pd_dumpall -g If you don't need seperate backups of each database inside postgresql, it's eysier to use pg_dumpall.

    • -1