General Q & A ▶ Can a PostgreSQL AWS instance be used : add message

::
(ctrl+enter)    


Previous messages in the topic:
andrew.paterson@decisions.com
9/14/2021
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.
Twoh
9/13/2021
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

9/9/2021
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
Twoh
9/9/2021
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?
Brian@decisions.com
4/4/2019
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
CleverPeanut
4/4/2019
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!




Powered by Jitbit Forum 8.3.8.0 © 2006-2013 Jitbit Software