Skip to main content
17-Peridot
July 9, 2019
Solved

Can thingworx has multiple tablespaces for Postgresql ?

  • July 9, 2019
  • 2 replies
  • 874 views

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

Best answer by zyuan1

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

2 replies

zyuan15-Regular MemberAnswer
5-Regular Member
July 10, 2019

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

5-Regular Member
July 10, 2019

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