strapi-cms / config /database.js
kenken999
fix: use Strapi v4 official 'schema: strapi' option instead of searchPath/options workarounds
2eb5f53
raw
history blame contribute delete
620 Bytes
module.exports = ({ env }) => ({
connection: {
client: 'postgres',
connection: {
host: env('DATABASE_HOST', '127.0.0.1'),
port: env.int('DATABASE_PORT', 5432),
database: env('DATABASE_NAME', 'postgres'),
user: env('DATABASE_USERNAME', 'strapi'),
password: env('DATABASE_PASSWORD', ''),
ssl: { rejectUnauthorized: false },
// Strapi v4 公式: schema オプションで Supabase public スキーマと完全分離
schema: 'strapi',
},
acquireConnectionTimeout: env.int('DATABASE_CONNECTION_TIMEOUT', 60000),
debug: false,
},
});