• Creating dump your DataBase
• Copy dump of Databases to new Sever TMS
• Creating Database
• Restore the Dump of Database
• Deploy new TMS
• Post migration procedure

Create dump your PostgreSQL Database with “pg_dump” tool

pg_dump -U tvip-tms tvip-tms >  /backup/tvip-tms.sql

If you need make dumps of others Databases

pg_dump -U tvip-tms tvip-tms-audit >  /backup/tvip-tms-audit.sql
pg_dump -U tvip-tms tvip-tms-vod >  /backup/tvip-tms-vod.sql

Copy Dump of Database to new TMS Server with “scp” tool.

scp /backup/tvip-tms.sql username@host:/backup/

Before install TVIP TMS, you should install PostgreSQL and restore dump of Database.

• Setup and check of locale

Run this cli command:

sudo dpkg-reconfigure locales

Make sure the locale is selected: “[*] en_US.UTF-8 UTF-8” and others locale what you need, and select them if you'd like it.

• Install PostgreSQL Database:

sudo apt -y install postgresql

• Create database: tvip-tms with user: tvip-tms

sudo -u postgres psql
createuser tvip-tms && createdb -O tvip-tms tvip-tms;
\q

If you use other databases then create them:

sudo -u postgres psql
createdb -O tvip-tms tvip-tms-audit;
createdb -O tvip-tms tvip-tms-vod;
\q

• Restore the Dump of Database:

psql -U tvip-tms tvip-tms  < /backup/tvip-tms.sql

• Reset authentication keys auth key:

psql -U tvip-tms tvip-tms
update device set authkey = '';
\q

Make sure, your server has minimal system requirements
system requirements:

• Intel(R) Xeon(R) CPU E5-2630 v4 @ 2.20GHz
• Minimum 32 GB of RAM
• Minimum 500 GB (free disk space) for minimum 4000 active and online devices.

echo "deb http://deb.packages.tvip.ru/ xenial main" >> /etc/apt/sources.list.d/tms.list
wget --quiet -O - http://deb.packages.tvip.ru/deploy/key.asc | apt-key add -
apt-get update
apt-get install tvip-tms-standalone

• Enable “Allow quick biding​” for your Provider
  
• Change ip of server or change DNS record to route clients to new TMS.