30 lines
1.0 KiB
JavaScript
30 lines
1.0 KiB
JavaScript
// ============================================================
|
|
// db.js — PostgreSQL database connection
|
|
// ============================================================
|
|
// We use the 'pg' package to talk to PostgreSQL.
|
|
// A "Pool" keeps multiple connections open so requests don't
|
|
// have to wait for a single connection to free up.
|
|
// ============================================================
|
|
|
|
const { Pool } = require('pg');
|
|
|
|
// Read database settings from .env file
|
|
const pool = new Pool({
|
|
host: process.env.DB_HOST, // e.g. 'localhost'
|
|
port: process.env.DB_PORT, // e.g. 5432
|
|
database: process.env.DB_NAME, // e.g. 'auth_db'
|
|
user: process.env.DB_USER, // e.g. 'postgres'
|
|
password: process.env.DB_PASSWORD, // your postgres password
|
|
});
|
|
|
|
// Test the connection when the server starts
|
|
pool.connect((err) => {
|
|
if (err) {
|
|
console.error('Database connection error:', err.message);
|
|
} else {
|
|
console.log('Connected to PostgreSQL database!');
|
|
}
|
|
});
|
|
|
|
module.exports = pool;
|