question

Sean avatar image
0 Likes"
Sean asked Jason Lightfoot edited

postgreSQL database connect error

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

FlexSim 23.0.4
database connectorpostgresql
database.png (16.4 KiB)
5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jason Lightfoot avatar image
0 Likes"
Jason Lightfoot answered Jason Lightfoot edited

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.

5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Steven Hamoen avatar image
0 Likes"
Steven Hamoen answered

@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.

5 |100000

Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.