Can thingworx has multiple tablespaces for Postgresql ?

[seanccc]

Hi, 

The tablespace "thingworx" is created by default if install Thingworx  in Posgresql.   If the Thingworx server has two hard disks and each one is 1T,  is it possible to create another tablespace like "thingworxTwo" in the 2nd hard disk so that Thingworx can make use of the server's storage ? 

Regards,

Sean

[zyuan1 · Accepted solution]

1 pgSQL instance can only be installed in one disk, but if you installed 2 pgSQL instance, you can keep the data separately, and view them in the same pgAdmin UI with different port number.

And by doing this, you are applying additional Persistence Provider to Twx server

https://www.ptc.com/en/support/article?n=CS262935&posno=1&q=additional%20persistence&source=search

[zyuan1]

Applying this you'll have twice the storage space and twice the SQL core computing resource