-
Read MoreNo Image
psql -U postgres -d video_metadata -c "select (select path from video_file where id =video_file_id) from watch_status where uid=
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...Date2018.12.25 Category데이터베이스 Views229 -
Read MoreNo Image
RSS Backup (Download Station RSS Backup script)
pg_dump -U postgres download -t rss_feed -a -f /volume2/XTRM_DSM/rss_feed.sqlDate2018.05.27 Category데이터베이스 Views181 -
Read MoreNo Image
Download Station Auto Delete - content
psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[E Channel]%'" psql -U postgres -d download -c "delete FROM download_queue WHERE filename like '%[K Star]%'" psql -U postgres -d download -c "delete FROM downl...Date2018.02.11 Category데이터베이스 Views166 -
Read MoreNo Image
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')"'Date2018.02.11 Category데이터베이스 Views188