HomeGeneral Q & A

Can a PostgreSQL AWS instance be used Messages in this topic - RSS add reply

CleverPeanut
CleverPeanut
Posts: 80


4/4/2019
CleverPeanut
CleverPeanut
Posts: 80
Salutations fellow earth brethren!



Just curious if you support the ability to use an AWS hosted PostgreSQL engine versus AWS MS SQL?


Blessed cheese and milky way to you!
0 link reply with quote
Guest


9/9/2021
Guest
Hi Twoh,

The connection string expected may be a different format for Postgresql. I believe it is something similar to:
Server=192.168.1.163;Port=5432;Database=postgres;User Id=postgres;Password=root;




Another consideration to make is making sure traffic is allowed across port 5432 on the server where Decisions is hosted and on your database server.

I hope this helps!

-Andrew
+1 link reply with quote
andrew.paterson@decisions.com
andrew.paterson@decisions.com
Administrator
Posts: 11


9/14/2021
andrew.paterson@decisions.com
andrew.paterson@decisions.com
Administrator
Posts: 11
Hi Twoh,

This looks like a permissions error. It might be worth testing the connection between your application server and PGSQL machine. This can be done by downloading a management tool onto your application server such as pgAdmin or using a UDL file to make sure that machine can connect.

To answer your question, Decisions uses v5.0.7 NPGSQL Connector but I do not think version difference is the cause here.
+1 link reply with quote


(Ctrl+Enter)




Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software