System Information
- Strapi Version: 4.4.3
- Operating System: Ubuntu Server
- Database: PostgreSQL 14
- Node Version: v.16.17.0
- NPM Version: 8.15.0
- Yarn Version: -
Hi i need to query another database on the same host. I made several attempts by editing the database.js file but failed. I’m not sure if this is possible. Has anyone been able to do this before?
-
Strapi Database
– Strapi Schema -
Custom Database
– Client Informations
// ./config/database.js
const path = require('path');
module.exports = ({ env }) => ({
connection: {
client: 'postgres',
connection: {
host: env('DATABASE_HOST', 'HOST'),
port: env.int('DATABASE_PORT', 25060),
database: env('DATABASE_NAME', strapi
user: env('DATABASE_USERNAME', 'doadmin'),
password: env('DATABASE_PASSWORD', 'PASS'),
schema: env('DATABASE_SCHEMA', 'public'), // Not required
ssl: {
rejectUnauthorized: env.bool('DATABASE_SSL_SELF', false),
},
},
debug: false
},
userData: { //second database
client: 'postgres',
connection: {
host: env('DATABASE_HOST', 'HOST'),
port: env.int('DATABASE_PORT', 25060),
database: env('DATABASE_NAME', 'userData'),
user: env('DATABASE_USERNAME', 'doadmin'),
password: env('DATABASE_PASSWORD', 'PASS'),
schema: env('DATABASE_SCHEMA', 'public'), // Not required
ssl: {
rejectUnauthorized: env.bool('DATABASE_SSL_SELF', false),
},
},
debug: false,
}
});