George Ilyes gilyes

Install Dropbox and Python script. Symlink Python script to /usr/local/bin/dropbox and make it executable.

#/etc/systemd/system/dropbox.service

[Unit]
Description=Dropbox Service
After=network.target

[Service]

	SELECT pg_terminate_backend(pg_stat_activity.pid)
	FROM pg_stat_activity
	WHERE pg_stat_activity.datname = 'TARGET_DB'
	AND pid <> pg_backend_pid();

	Backup:
	docker exec -t -u postgres your-db-container pg_dumpall -c > dump_`date +%d-%m-%Y"_"%H_%M_%S`.sql

	Restore:
	cat your_dump.sql \| docker exec -i your-db-container psql -Upostgres