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

Community Tip - Need help navigating or using the PTC Community? Contact the community team. X

Unable to connect single PostgreSQL Database to multiple Thingworx instances?

njain-21
1-Visitor

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.

ACCEPTED SOLUTION

Accepted Solutions
posipova
20-Turquoise
(To:njain-21)

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.

View solution in original post

1 REPLY 1
posipova
20-Turquoise
(To:njain-21)

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.

Announcements


Top Tags