cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Need to share some code when posting a question or reply? Make sure to use the "Insert code sample" menu option. Learn more! X

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

psaxena
1-Newbie

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

4 REPLIES 4

I am using Postgre sql, and I wanted the backup of Thingworx data in Thingworx Storage.

gallan
4-Participant
(To:psaxena)

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

qngo
5-Regular Member
(To:psaxena)

Possibility of Creating an extension for ThingWorx Postgres Data Backup

Using psql terminal or PdAdmin III tool

pg_dump -h localhost -p 5432 -U postgres thingworx > D:\filename.sql


Full documentation

Chapter 24. Backup and Restore

Top Tags