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

Community Tip - Learn all about the Community Ranking System, a fun gamification element of the PTC Community. X

Need help on the Relational Databases Connectors Extension. [PostgreSQL Thing]

srawat
2-Guest

Need help on the Relational Databases Connectors Extension. [PostgreSQL Thing]

The Relational Databases Connectors Extension provides a Thing Template to connect to the PostgreSQL which I configured as given in the User Guide that come with the extension. Gave the connection details of the PostgreSQL database server installed on the local machine. Created a service with SQL command, to connect to the database and access the tables, but while executing the service, it gave following error - [Unable to Invoke Service postgresql_service on PostgreThing : Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections]. Re-verified configuration settings, PostgreSQL server is also running, but still the error occurs. Suggestions needed, anybody who has used this extension?

1 REPLY 1
ttielebein
12-Amethyst
(To:srawat)

Hello,

Are you sure you are setting up the service right? You say here that you created a SQL command to connect to the database and access tables, but you need a SQL query if you are accessing tables or like just doing a SELECT or something similar. The SQL command scripting mode is for UPDATE, INSERT, DELETE, etc.

Hope this helps!

Tori

Top Tags