Function resolvePostgresPoolConfig

src/config/postgres.js:76–103

()

}

export function resolvePostgresPoolConfig() {
    const ssl = resolveSslConfig();
    const url = (process.env.POSTGRES_URL || process.env.DATABASE_URL || '').trim();
    const sharedOptions = {
        max: parseInt(process.env.POSTGRES_MAX_CONNECTIONS) || 20,
        min: parseInt(process.env.POSTGRES_MIN_CONNECTIONS) || 2,
        idleTimeoutMillis: parseInt(process.env.POSTGRES_IDLE_TIMEOUT) || 30000,
        connectionTimeoutMillis: parseInt(process.env.POSTGRES_CONNECTION_TIMEOUT) || 10000,
        application_name: 'titanbot',
        statement_timeout: process.env.NODE_ENV === 'production' ? 30000 : 0,
        keepalives: 1,
        keepalives_idle: 30,
        ssl,
    };

    if (url && url !== DEFAULT_POSTGRES_URL) {
        return { connectionString: url, ...sharedOptions };
    }

    return {
        host: process.env.POSTGRES_HOST || 'localhost',
        port: parseInt(process.env.POSTGRES_PORT) || 5432,
        database: process.env.POSTGRES_DB || 'titanbot',
        user: process.env.POSTGRES_USER || 'postgres',
        password: (process.env.POSTGRES_PASSWORD || '').toString(),
        ...sharedOptions,
    };
}

export const pgConfig = {
    url: process.env.POSTGRES_URL || process.env.DATABASE_URL || DEFAULT_POSTGRES_URL,