시놀로지ㆍNAS/데이터베이스5 시놀로지 다운로드스테이션 RSS 백업 복원 (Synology Download Station RSS) 시놀로지 다운로드스테이션 RSS 백업 복원 (Synology Download Station RSS) 백업 pg_dump -U postgres download -t rss_feed -a -f /volume2/XTRM_DSM/rss_feed.sql 복원 psql -U postgres download 2021. 4. 25. Synology Video Station User Logs Synology Video Station User Logs cd /volume2/XTRM_DSM/_VideoStation/ mkdir `date +%Y%m%d` echo 사용자번호_사용자명 >> /volume2/XTRM_DSM/_VideoStation/`date +%Y%m%d`/사용자명_`date +%Y%m%d`.txt; psql -U postgres -d video_metadata -c "select (select path from video_file where id =video_file_id) from watch_status where uid = 사용자번호" >> /volume2/XTRM_DSM/_VideoStation/`date +%Y%m%d`/사용자명_`date +%Y%m%d`.txt; -----.. 2021. 4. 23. RSS Backup (Download Station RSS Backup script) RSS Backup (Download Station RSS Backup script) pg_dump -U postgres download -t rss_feed -a -f /volume2/XTRM_DSM/rss_feed.sql 2021. 4. 23. Download Station Auto Delete - content Download Station Auto Delete - content psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%450p%'" psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%450%'" psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%360p%'" psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%360%'" 2021. 4. 23. Download Station Auto Delete Download Station Auto Delete su - postgres -c 'psql -U postgres -d download -c "delete from Download_queue where status in ('5','7','8','113','123')"' 2021. 4. 23. 이전 1 다음 반응형
