postgreSQL database connect error

postgreSQL database connect error

hsiangchao
Not applicable
198 Views
2 Replies
Message 1 of 3

postgreSQL database connect error

hsiangchao
Not applicable

[ FlexSim 23.0.4 ]

Hi,

I tried to connect postgreSQL. We set port 54321、1433, both of port show error. Then we try to set port 5432, it can connect. Can flexsim connect port 5432 only? If it can connect another port, how to write address? We try to write 192.XXX.XX.XX@54321、192.XXX.XX.XX:54321、192.XXX.XX.XX/54321, all of them show error. Thank's.database.png

0 Likes
Accepted solutions (1)
199 Views
2 Replies
Replies (2)
Message 2 of 3

SCHamoen
Advisor
Advisor

@Sean I don't think FlexSim is limited to any port whatsoever. I would first look at your windows firewall if the correct ports are opened and if FlexSim has the rights to use those ports.

0 Likes
Message 3 of 3

jason_lightfoot_adsk
Autodesk
Autodesk
Accepted solution

The documentation suggests "hostname,port" might work for the address.

If not you can try entering the connection string as described here for the parameter sDBstring.

If both of those fail, then check which port the process is using via netstat.

Additionally the documentation suggests the connector requires libpq version 7.1.x or higher.

0 Likes