backup/postgresqlBackup

Backing up Postgresql databases running in Docker container

Configuration

Please create a configuration file which defines the following variables.

#Where to put the sql dumps
backupFilepath="/var/joplin/postgresql_backup/"
#How many dumps shall be kept
rotationDays=7
#Database settings
dockerContainerName=docker_postgresql 
dbUser=joplin
dbPasswd=123456789
dbName=joplin

Pass this configuration file as parameter to the script. To automate the backup job, I recommend to put the script in your crontab:

50 2 * * * root /root/scripts/backup/postgresqlBackup/backup_postgresql /root/scripts/backup/postgresqlBackup/joplinBackup.conf