NongBritee (ไบร์ท)
NongBritee (ไบร์ท)
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
yes bro
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
No description
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
ok I got it, for now It not reach max capacity yet
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
ok thanks, but any plan in future ?
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
I mean I have client A -> for A billing, then client B in my same email account -> then B billing
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
In railway can I seperate billing on each project depends on my clients
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
let see tomorrow
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
Wow It's really good template, I think it should work
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
Ah i see, sorry for misunderstanding
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
const path = require('path');

module.exports = ({ env }) => {
const client = env('DATABASE_CLIENT', 'postgres');

const connections = {
postgres: {
connection: {
connectionString: env('DATABASE_URL'),
host: env('DATABASE_HOST', 'localhost'),
port: env.int('DATABASE_PORT', 5432),
database: env('DATABASE_NAME', 'strapi'),
user: env('DATABASE_USERNAME', 'strapi'),
password: env('DATABASE_PASSWORD', 'strapi'),
ssl: env.bool('DATABASE_SSL', false) && {
key: env('DATABASE_SSL_KEY', undefined),
cert: env('DATABASE_SSL_CERT', undefined),
ca: env('DATABASE_SSL_CA', undefined),
capath: env('DATABASE_SSL_CAPATH', undefined),
cipher: env('DATABASE_SSL_CIPHER', undefined),
rejectUnauthorized: env.bool(
'DATABASE_SSL_REJECT_UNAUTHORIZED',
true
),
},
schema: env('DATABASE_SCHEMA', 'public'),
},
pool: {
min: 0,
max: 10,
idleTimeoutMillis: Number.MAX_SAFE_INTEGER,
},
},
};

return {
connection: {
client,
...connections[client],
acquireConnectionTimeout: 60000,
},
};
};
const path = require('path');

module.exports = ({ env }) => {
const client = env('DATABASE_CLIENT', 'postgres');

const connections = {
postgres: {
connection: {
connectionString: env('DATABASE_URL'),
host: env('DATABASE_HOST', 'localhost'),
port: env.int('DATABASE_PORT', 5432),
database: env('DATABASE_NAME', 'strapi'),
user: env('DATABASE_USERNAME', 'strapi'),
password: env('DATABASE_PASSWORD', 'strapi'),
ssl: env.bool('DATABASE_SSL', false) && {
key: env('DATABASE_SSL_KEY', undefined),
cert: env('DATABASE_SSL_CERT', undefined),
ca: env('DATABASE_SSL_CA', undefined),
capath: env('DATABASE_SSL_CAPATH', undefined),
cipher: env('DATABASE_SSL_CIPHER', undefined),
rejectUnauthorized: env.bool(
'DATABASE_SSL_REJECT_UNAUTHORIZED',
true
),
},
schema: env('DATABASE_SCHEMA', 'public'),
},
pool: {
min: 0,
max: 10,
idleTimeoutMillis: Number.MAX_SAFE_INTEGER,
},
},
};

return {
connection: {
client,
...connections[client],
acquireConnectionTimeout: 60000,
},
};
};
I have updated, let see tomorrow, thank bro
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
No description
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
here is my database.js
const path = require('path');

module.exports = ({ env }) => {
const client = env('DATABASE_CLIENT', 'postgres');

const connections = {
postgres: {
connection: {
connectionString: env('DATABASE_URL'),
host: env('DATABASE_HOST', 'localhost'),
port: env.int('DATABASE_PORT', 5432),
database: env('DATABASE_NAME', 'strapi'),
user: env('DATABASE_USERNAME', 'strapi'),
password: env('DATABASE_PASSWORD', 'strapi'),
ssl: env.bool('DATABASE_SSL', false) && {
key: env('DATABASE_SSL_KEY', undefined),
cert: env('DATABASE_SSL_CERT', undefined),
ca: env('DATABASE_SSL_CA', undefined),
capath: env('DATABASE_SSL_CAPATH', undefined),
cipher: env('DATABASE_SSL_CIPHER', undefined),
rejectUnauthorized: env.bool(
'DATABASE_SSL_REJECT_UNAUTHORIZED',
true
),
},
schema: env('DATABASE_SCHEMA', 'public'),
},
pool: {
min: env.int('DATABASE_POOL_MIN', 0),
max: env.int('DATABASE_POOL_MAX', 10),
idleTimeoutMillis: env.int('DATABASE_POOL_IDLE_TIMEOUT', Number.MAX_SAFE_INTEGER),
},
},
};

return {
connection: {
client,
...connections[client],
acquireConnectionTimeout: env.int('DATABASE_CONNECTION_TIMEOUT', 60000),
},
};
};
const path = require('path');

module.exports = ({ env }) => {
const client = env('DATABASE_CLIENT', 'postgres');

const connections = {
postgres: {
connection: {
connectionString: env('DATABASE_URL'),
host: env('DATABASE_HOST', 'localhost'),
port: env.int('DATABASE_PORT', 5432),
database: env('DATABASE_NAME', 'strapi'),
user: env('DATABASE_USERNAME', 'strapi'),
password: env('DATABASE_PASSWORD', 'strapi'),
ssl: env.bool('DATABASE_SSL', false) && {
key: env('DATABASE_SSL_KEY', undefined),
cert: env('DATABASE_SSL_CERT', undefined),
ca: env('DATABASE_SSL_CA', undefined),
capath: env('DATABASE_SSL_CAPATH', undefined),
cipher: env('DATABASE_SSL_CIPHER', undefined),
rejectUnauthorized: env.bool(
'DATABASE_SSL_REJECT_UNAUTHORIZED',
true
),
},
schema: env('DATABASE_SCHEMA', 'public'),
},
pool: {
min: env.int('DATABASE_POOL_MIN', 0),
max: env.int('DATABASE_POOL_MAX', 10),
idleTimeoutMillis: env.int('DATABASE_POOL_IDLE_TIMEOUT', Number.MAX_SAFE_INTEGER),
},
},
};

return {
connection: {
client,
...connections[client],
acquireConnectionTimeout: env.int('DATABASE_CONNECTION_TIMEOUT', 60000),
},
};
};
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
@Brody
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
No description
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
Hi bro It still have an issue
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
No description
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
Hi brody
37 replies
RRailway
Created by NongBritee (ไบร์ท) on 10/14/2023 in #✋|help
My strapi + postgres sql is always disconnect when idle a long time
04ff73c6-ae95-43b1-a420-8a274e65c9e2
37 replies