Description
Hi folks--I am trying to set up Spoke on a managed service (Render); I can build and deploy the app but seem to be unable to connect to the database; this error appears after deployment and when I try to log in:
TimeoutError: Knex: Timeout acquiring a connection. The pool is probably full. Are you missing a .transacting(trx) call?
The environment variables I think are relevant:
DB_TYPE=pg
DB_HOST=oregon-postgres.render.com
DB_NAME=spoke_testing
DB_PORT=5432
DB_USER=spoke_testing_user
DB_USE_SSL=require[I've also tried false]
PGSSLMODE=require[I've also tried false; not sure how this and ^^ interact]
DB_PASSWORD=[redacted]
NODE_ENV=production
Build command: yarn install
Launch command: npm start
And again the app does load, I can see the splash page and get to Auth0, but upon callback it won't load, and when I look in the db I don't see any of the spoke tables built.
I also don't think I have messed up the credentials themselves because I can connect to this database with these credentials using a SQL GUI tool; but almost certainly I've mis-set something elsewhere, or there's something else about this particular approach to deployment that I'm doing wrong, versus there being an outright bug. I appreciate your help!