How can we take regular backups of our Thingworx data through a service which runs at regular intervals.

There is a guide to backing up a Postgre DB here,​ I use a simple script on my development (windows) PC based on the linked document:

F:/postgreSQL/db01/bin\pg_dump.exe --host localhost --port 5432 --username "postgres" --no-password  --format custom --blobs --verbose --file "F:\ThingworxDBBackup\Thingworxdata%date:~6,4%%date:~3,2%%date:~0,2%.backup" "thingworx"
move "F:\ThingworxDBBackup\Thingworxdata%date:~6,4%%date:~3,2%%date:~0,2%.backup" E:\Backups\

The first line dumps the database and the second moves the dump file to a secondary drive