1 Reply Latest reply on Aug 14, 2017 10:19 PM by polinao RSS
    njain-2 Newbie

    Unable to connect single PostgreSQL Database to multiple Thingworx instances?

    PosreSQL is allowing me one Thingworx instance connection at one time, as soon as I try another it do not connect or if this connect other Instance's session time occur.

      • Re: Unable to connect single PostgreSQL Database to multiple Thingworx instances?
        polinao Collaborator

        As a short answer, it is not possibl.

        To elaborate, the architecture allows only one platform for the database support at any given time. When your second instance tries to claim the database, it sees an existing foreign ownership and denies it.

        In theory, if there was a workaround for the ownership flag, the second problem is a lot more complex and unavoidable: the platform heavily relies on in-memory model of the system. For example, gets sets deletes on properties are stored in the DB but not read. Reads are done from in -memory. The only time the DB reads happen when things are restarted (and some other trivial use cases) - to rehydrate.