Colin MacDonald OneWeb
OneWeb
/ sonata_media_path.sql
Created
April 22, 2016 07:55
— forked from mhouchin/sonata_media_path.sql
PostgreSQL function to generate sonata media path
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| -- Function: public.sonata_media_path(bigint, text, text, text) | |
| -- DROP FUNCTION public.sonata_media_path(bigint, text, text, text); | |
| CREATE OR REPLACE FUNCTION public.sonata_media_path( | |
| id bigint, | |
| context text, | |
| size text, | |
| reference text) | |
| RETURNS text AS |
OneWeb
/ subsonic-backup-data-ubuntu
Last active
February 23, 2016 12:04
Subsonic Backup Data on Ubuntu
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| #!/bin/bash | |
| SUBSONIC_DATA=/var/subsonic/db | |
| SUBSONIC_NEW_DATA=/media/bigbird/Backups/subsonic/ | |
| service subsonic stop | |
| sleep 45 | |
| rsync -a $SUBSONIC_DATA $SUBSONIC_NEW_DATA | |
| service subsonic start |