Skip to main content
S
SV_1019722111-Garnet
11-Garnet
April 17, 2023
Solved

Can we install ThingWorx on one server and connect it to the existing PostgreSQL server?

  • April 17, 2023
  • 1 reply
  • 1881 views

Hi,

 

Let say we have this previous configuration,

Thingworx Platform server (Server 1)  -----connected----->  PostgressSQL( Server 2)

 

Now I want to install thingworx Platform on new server say server 3, migrate everything from server 1 platform to this new Platform  and connect it with existing postgress server on server 2. Like the configuration shown below,

 

New Thingworx Platform server (Server 3) ------connected----> PostgressSQL( Server 2)

 

Is this possible. If yes, can someone suggest an optimized steps.

 

Thanks

 

 

 

 

Best answer by slangley

Hi @SV_10197221.

 

You can achieve both connections easily in ThingWorx. 

 

For either connection, create a new Thing using "Database" as the Base Thing Template.  Then select the Configuration tab to configure the connection parameters.   I'm assuming you're running a recent version of ThingWorx. 

 

Here's a link to the Help Center that should help to answer some of your questions.  In addition, here's a link to a training guide from ThingWorx IoT Tips located in the community. 

 

And to answer your question, you can't have 2 db's with the same name on the same database instance.  ThingWorx doesn't require the persistance provider or external databases to be called "thingworx".  The person creating the database and installing the product would have made the decision around the database name.

 

Please let me know if you have further questions.

 

Regards.

 

--Sharon

1 reply

S
slangleyCommunity Manager
Community Manager
April 17, 2023

Hi @SV_10197221 

 

To answer your question appropriately, we need additional information.

 

PostgreSQL can host multiple databases.  Is your question around installation of a new ThingWorx instance connecting to a new db on the existing PostgreSQL server, or are you asking if the new ThingWorx instance can connect to the original ThingWorx database?  The answer to both is yes, but depending on the specifics, the process may vary. 

 

The procedure will also vary depending on whether you are installing the same version of ThingWorx on the new server as that running in the original implementation.  What version of ThingWorx are you currently running and what version of ThingWorx are you planning to install on the new server?

 

Regards.

 

--Sharon

    S
    SV_1019722111-GarnetAuthor
    11-Garnet
    April 18, 2023

    Hi Sharon,

     

    'Is your question around installation of a new ThingWorx instance connecting to a new db on the existing PostgreSQL server, or are you asking if the new ThingWorx instance can connect to the original ThingWorx database?"

    • I want to connect the new ThingWorx instance to the original ThingWorx database.
    • Am also considering  to connect the new ThingWorx instance to a new db on the existing PostgreSQL server. But how will that work. Because thingworx create its own database with name 'thingworx' during installation, and if there is already a db by that name wont there be a conflict. 

    Would be great if you can help me understand both these points and share a systematic procedures to do the respective setup.

     

    And the versions

    Existing                       : Thingworx Platform server 8.4.15 (Server 1)  -----connection----->  PostgressSQL 10.13 ( Server 2)

    Want to implement : New Thingworx Platform server 8.5.18(Server 3) ------connection----> PostgressSQL 10.13 ( Server 2)

     

     

    Thanks,

    Sri

    S
    SV_1019722111-GarnetAuthor
    11-Garnet
    April 18, 2023

    Sorry, correction.

    The PostgreSQL version is 10.13

    Terms & ConditionsCookie settingsAccessibility statement