Postgres Slow connection from jsreport
-
Hey JSReport team,
We recently switched from MSSQL to PostgreSQL for our template store. We're experiencing a specific connection issue where the connection can take around 30 minutes to establish, but subsequent connections are fast.
Details:
- Happens to multiple team members across different locations
- Usually affects the first connection after a period of inactivity (usually overnight)
- Other connections with db tools to the same database are quick
- Once connected, jsreport works normally and reconnects quickly
Current config:
"ssl": { "rejectUnauthorized": false, },Has anyone seen similar behavior with PostgreSQL? We suspect it might be related to connection initialization or how jsreport handles database schema verification on startup, but we're not sure.
Any insights would be appreciated!
-
jsreport uses quite an outdated PostgreSQL client.
We will update it with the next release, coming in the next few days; perhaps that will help.