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
Brian@decisions.com
Brian@decisions.com
Administrator
Posts: 89


4/4/2019
Brian@decisions.com
Brian@decisions.com
Administrator
Posts: 89
Humble Peanut,

Our workflow and rule engine is able to integrate with POSTGRES and all other types of RDS, but Decisions does require either MSSQL, or AZURE SQL, to run as an application. That being said, you can construct all of your business processes/logic to read data from and write it back to your POSTGRES database(s).


Bumblebee tuna
0 link reply with quote
Twoh
Twoh
Posts: 2


9/9/2021
Twoh
Twoh
Posts: 2
Hello,

I've been working on getting a Database Connection set up as Postgresql. I've been trying both with/without the Custom Connection String. I have my connections string formatted thusly:

User ID=USERID;Password=PASSWORD;Host=Yaddayadda.us-east-1.rds.amazonaws.com;Port=5432;SSL=true;

I'm receiving an error running the TEST saying "Test Failed: Failed to establish a connection to (my server name)"

Version 6.12.1 rev 64872

Any advice on getting this connection set up?
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
Twoh
Twoh
Posts: 2


9/13/2021
Twoh
Twoh
Posts: 2
Thanks for the reply Andrew, that was very helpful. I've verified that port 5432 is open, and tried with this type of connection string. I'm still hitting

Message]:Start Test Connection Npgsql.NpgsqlException: [Exception]:Npgsql.NpgsqlException: Failed to establish a connection to 'sales-center-read-replica.cqtslxopt5pe.us-east-1.rds.amazonaws.com'. at Npgsql.NpgsqlClosedState.Open(NpgsqlConnector context) at Npgsql.NpgsqlConnector.Open() at Npgsql.NpgsqlConnectorPool.GetPooledConnector(NpgsqlConnection Connection) at Npgsql.NpgsqlConnectorPool.RequestPooledConnectorInternal(NpgsqlConnection Connection) at Npgsql.NpgsqlConnectorPool.RequestPooledConnector(NpgsqlConnection Connection) at Npgsql.NpgsqlConnectorPool.RequestConnector(NpgsqlConnection Connection) at Npgsql.NpgsqlConnection.Open() at DecisionsFramework.Data.ORMapper.DatabaseDrivers.DatabaseDriversHelper.TestConnection(DataBaseTypeEnum type, String connectionString, String databaseFolderId) at DecisionsFramework.ServiceLayer.Services.DatabaseIntegration.DefinitionServices.DatabaseDataService.StartTestConnection(AbstractUserContext userContext, DataBaseTypeEnum type, String connectionString, String agentId, Boolean useCurrentDatabase)

I'm now looking into what version of NPGSQL the connector is using. Can you look and find out what version is shipped with Decisions?

Thanks
0 link reply with quote
andrew.paterson@decisions.com
andrew.paterson@decisions.com
Administrator
Posts: 8


9/14/2021
andrew.paterson@decisions.com
andrew.paterson@decisions.com
Administrator
Posts: 8
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