KristianWood
05-01-2024Data Storage
Timeout on Postgresql connections in dev environment after 3 min
Whenever I build the ClimateCube in our dev environment 3 times out of 4 one of two tables will time out after 3 min. The tables are DocumentChatEmbeddingProcess and PL2, and in both cases when they time out its after 3 min, but when they don't time out it takes longer than 3 min.
I have set the timeout in Sisense.Connectors.PostgreSqlConnector.dll.config to <add key="Timeout" value="900" /> but this makes no difference
The error I get when the build fails is:
"A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond"