I deploy strapi on the render platform. strapi builds correctly, but I get this error when connecting to the postgeSQL database on render:
Error: getaddrinfo EAI_AGAIN dpg-cjk5hqdk5scs73a7f9b0-a
at GetAddrInfoReqWrap.onlookup [as oncomplete] (node:dns:108:26) {
errno: -3001,
code: ‘EAI_AGAIN’,
syscall: ‘getaddrinfo’,
hostname: ‘dpg-cjk5hqdk5scs73a7f9b0-a’
}
here is my code of database.js file in cand config folder:
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”,
“dpg-cjk5hqdk5scs73a7f9b0-a.oregon-postgres.render.com”),
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”, true) && {
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”, 2),
max: env.int(“DATABASE_POOL_MAX”, 10),
},
},
};
return {
connection: {
client,
…connections[client],
acquireConnectionTimeout: env.int(‘DATABASE_CONNECTION_TIMEOUT’, 60000),
},
};
};
here is my code of .env file:
HOST=0.0.0.0
PORT=1337
APP_KEYS=xgI/SRafr5NDkOifDuiXcQ==,spqXKRCWnK98fYAnpdaxiw==,z8l6wA7Mxw9rXqA+x5OD2w==,1W3zd7V+b4RqGWsAJrPOdA==
API_TOKEN_SALT=sDfDOJYb0VxYf1QuylsS5w==
ADMIN_JWT_SECRET=GEskwiNd+WSorLG0RUS+Qw==
TRANSFER_TOKEN_SALT=TymXzlMDRmuDW7Jp/lvRdg==
Database
DATABASE_CLIENT=postgres
DATABASE_HOST=dpg-cjk5hqdk5scs73a7f9b0-a.oregon-postgres.render.com
DATABASE_PORT=5432
DATABASE_NAME=raconte_b7wq
DATABASE_USERNAME=admin
DATABASE_PASSWORD=eZGVv8nPkYbbxH0YbNKdSqGZeGWil5dc
DATABASE_SSL= true
DATABASE_URL=postgres://admin:eZGVv8nPkYbbxH0YbNKdSqGZeGWil5dc@dpg-cjk5hqdk5scs73a7f9b0-a/raconte_b7wq