Webpack打包AWS Lambda代码时pg包安装报错求助

问题根源 #

1. Webpack配置中babel-loader的include参数错误：传入了模块对象pg而非实际文件路径，导致pg模块未被正确处理。
2. pg模块包含动态加载逻辑，Webpack默认打包规则会破坏其加载路径，使得Sequelize无法识别pg模块。

解决方案步骤 #

1. 修正Webpack配置的路径错误 #

将include中的模块对象替换为pg包的实际路径，同时规范迁移文件的路径匹配：

const path = require("path");
const glob = require("glob");

module.exports = {
    target: 'node',
    entry: './app.js', 
    module: {
        rules: [
            {
                test: /\.js$/,
                use: [{
                    loader: 'babel-loader',
                    options: {
                        include: [
                            path.resolve(__dirname, 'node_modules/pg'), // pg包的正确路径
                            ...glob.sync(path.resolve(__dirname, "../../database/migrations/*.js")) // 解析迁移文件绝对路径
                        ]
                    },
                }]
            },
        ]
    },
    devtool: 'source-map',
    output: {
        path: path.resolve(__dirname, "dist"),
        filename: '[name].js',
        libraryTarget: 'commonjs2',
    },
    // 排除AWS SDK（Lambda环境已内置，无需打包）
    externals: {
        'aws-sdk': 'aws-sdk'
    }
}

2. 显式指定Sequelize的dialectModule #

Webpack打包后模块解析路径会变化，需要手动将pg模块传入Sequelize，确保其能正确识别：

const sdk = require('aws-sdk');
const Sequelize = require('sequelize');
const pg = require('pg');
const { Umzug, SequelizeStorage } = require('umzug');

exports.handler = async function (event, context, callback) {
    let secretArn = process.env.DATABASE_SECRET_ARN;
    let db_user = process.env.DATABASE_USER;
    let db_endpoint = process.env.DATABASE_ENDPOINT;
    let db_port = process.env.DATABASE_PORT;
    let db_name = process.env.DATABASE_NAME;
    console.log('here',JSON.stringify(secretArn));
    try {
        console.log(secretArn);
        let secretResponse = await new sdk.SecretsManager().getSecretValue({ SecretId: secretArn }).promise();
        console.log('got the secret')
        let secretValue;
        if (secretResponse.SecretString) {
            secretValue = secretResponse.SecretString;
        } else {
            // 修正：此处应读取SecretBinary而非SecretString
            var buff = Buffer.from(secretResponse.SecretBinary, 'base64');
            secretValue = buff.toString('ascii');
        }
        let secretJson = JSON.parse(secretValue);

        console.log("Setting up connection");
        // 关键：手动传入pg模块作为dialectModule
        const sequelize = new Sequelize.Sequelize(db_name, db_user, secretJson.password, {
            host: db_endpoint,
            port: db_port,
            dialect: 'postgres',
            dialectModule: pg
        });
        
        // 可选：验证数据库连接
        await sequelize.authenticate();
        console.log('Connection has been established successfully.');
    } catch (error) {
        console.error('Unable to connect to the database:', error);
        callback(error);
    }
}

3. 可选：使用webpack-node-externals排除node_modules打包 #

若希望Lambda通过层或本地安装依赖，可安装webpack-node-externals避免打包所有node_modules：

npm install webpack-node-externals --save-dev

修改Webpack配置添加：

const nodeExternals = require('webpack-node-externals');

module.exports = {
    // ...其他配置
    externals: [nodeExternals()]
}

验证步骤 #

1. 重新执行打包：webpack --mode production
2. 将dist/main.js部署到Lambda
3. 触发Lambda测试，确认数据库连接成功

内容的提问来源于stack exchange，提问作者Panda Ninja