I am running in the same issue. I’m hosting on www.render.com.
My node Strapi service is running on 2 CPU and 4GB RAM.
My Postgres database is running on 2 CPU and 4GB RAM.
I’m using the following settings in /config/env/production/database.js
const { parse } = require("pg-connection-string");
module.exports = ({ env }) => {
const { host, port, database, user, password } = parse(env("DATABASE_URL"));
return {
connection: {
client: "postgres",
connection: {
host,
port,
database,
user,
password,
ssl: {
rejectUnauthorized: false,
},
},
debug: true,
pool: {
min: 0,
max: 10,
idleTimeoutMillis: 30000000,
createTimeoutMillis: 30000000,
acquireTimeoutMillis: 30000000,
propagateCreateError: false,
},
},
};
};