TTRSS Migration to New Server

  1. Prepare the old Server

  2. Stop the update service e.g. service ttrss stop

  3. Export the DB, assuming you're using Postgresql: sudo -u postgres pg_dump ttrss > dbdump

  4. Prepare new server[1]
    a. Install PHP: apt-get install php5 php5-fpm php5-curl php5-pgsql php5-gd php5-mcrypt php5-cli
    b. Install nginx mainline[2]
    c. Copy your old nginx config
    d. Install Postgresql apt-get install postgresql
    e. Login and create ttrss user and DB:

    sudo -u postgres psql postgres 
    \password postgres
    postgres=# CREATE USER ttrss WITH PASSWORD 'password';
    postgres=# CREATE DATABASE ttrssdb;
    postgres=# GRANT ALL PRIVILEGES ON DATABASE ttrssdb to ttrss;    
    \q
    

    f. Import old DB: sudo -u postgres psql ttrss < dbdump
    g. Grab the latest TT-RSS: git clone https://tt-rss.org/git/tt-rss.git tt-rss
    h. Connect to TTRSS via your browser, follow the instructions, but don't initialize DB


  1. https://davidbeath.com/posts/installing-tiny-tiny-rss-from-scratch.html ↩︎

  2. http://nginx.org/en/linux_packages.html ↩︎