TT-RSS用PostgreSQL運用メモ/ttrss-maint monthly.sh

TT-RSS用月次メンテナンス処理。

ttrss-maint_monthly.sh

#!/bin/sh

log() {
    dat=`date '+%Y-%m-%d %H:%M:%S'`
    if [ -p /proc/self/fd/0 ]
    then
        cat -
    else
        echo
    fi | sed -e "s/^/$dat LOG: /"
}

echo "START TT-RSS MONTHLY MAINTENANCE." | log

/etc/init.d/apache2 stop > /dev/null 2>&1
/etc/init.d/tt-rss  stop > /dev/null 2>&1

cat <<EOF | psql -e -U postgres tt-rss 2>&1 | log
CLUSTER VERBOSE ttrss_entries;
ANALYZE VERBOSE ttrss_entries;
CLUSTER VERBOSE ttrss_user_entries;
ANALYZE VERBOSE ttrss_user_entries;
EOF

/etc/init.d/apache2 start > /dev/null 2>&1
/etc/init.d/tt-rss  start > /dev/null 2>&1

echo "COMPLATE TT-RSS MONTHLY MAINTENANCE." | log