George Ilyes gilyes

## dropbox.service.md

      
              1 file
            
          
              0 forks
            
          
              0 comments
            
          
              0 stars
            
          
                gilyes
                / dropbox.service.md
            
            
              Last active
              June 16, 2016 06:14
                — forked from jsturgis/dropbox.service.md
            
              
                dropbox systemd 
              
          
    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]

  
## After kernel update, this may need to be run for docker to start working again
sudo apt-get install linux-image-extra-`uname -r` && sudo modprobe aufs

## Kill connections to postgres database
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, restore postgres in docker container
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
	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