无法在本地主机上的Koa上使用koa-pg中间件查询PG数据库

npm install koa pg

const { Pool } = require('pg');

const pool = new Pool({
  host: 'localhost',
  port: 5432,
  database: 'your_database',
  user: 'your_username',
  password: 'your_password',
});

module.exports = pool;

const Koa = require('koa');
const koaPg = require('koa-pg');
const pool = require('./db'); // 引入数据库连接配置

const app = new Koa();

app.use(koaPg(pool)); // 使用koa-pg中间件

app.use(async (ctx) => {
  // 执行数据库查询操作
  const result = await ctx.pg.query('SELECT * FROM your_table');
  ctx.body = result.rows;
});

app.listen(3000, () => {
  console.log('Server is running on port 3000');
});