Cannot Find Module during deployment

Support
1

The error message is

Error: Knex: run
$ npm install pg --save
Cannot find module 'pg'
Require stack:
- /var/task/node_modules/knex/lib/dialects/postgres/index.js
- /var/task/node_modules/knex/lib/dialects/index.js
- /var/task/node_modules/knex/lib/knex-builder/internal/config-resolver.js
- /var/task/node_modules/knex/lib/knex-builder/Knex.js
- /var/task/node_modules/knex/lib/index.js
- /var/task/node_modules/knex/knex.js
- /var/task/functions/api.js
- /var/task/api.js
- /var/runtime/index.mjs
    at Client_PG.initializeDriver (/var/task/node_modules/knex/lib/client.js:202:13)
    at new Client (/var/task/node_modules/knex/lib/client.js:83:12)
    at new Client_PG (/var/task/node_modules/knex/lib/dialects/postgres/index.js:21:5)
    at knex (/var/task/node_modules/knex/lib/knex-builder/Knex.js:16:28)
    at Object.<anonymous> (/var/task/functions/api.js:1:29)
    at Module._compile (node:internal/modules/cjs/loader:1364:14)
    at Module._extensions..js (node:internal/modules/cjs/loader:1422:10)
    at Module.load (node:internal/modules/cjs/loader:1203:32)
    at Module._load (node:internal/modules/cjs/loader:1019:12)
    at Module.require (node:internal/modules/cjs/loader:1231:19)

my netlify site name is https://main--merry-marzipan-5c66b7.netlify.app/.netlify/functions/api/programs

Netlify internal ID: 01HZ8PRB6GAMYKCVWJAH5S3HAB

I have include pg in my package.json file, and it is located at the root directory.
"dependencies": { "body-parser": "^1.20.2", "dotenv": "^16.4.5", "express": "^4.19.2", "knex": "^3.1.0", "nodemon": "^3.1.2", "pg": "^8.11.5", "serverless-http": "^3.2.0" }
this is the git repo: GitHub - wusixuan0/test-pg-netlify

Thank you so much for your help!

2

Your project won’t work on Netlify @wusixuan0 as Netlify does not provide a Node.js service.

More information

1 Like
3

Thank you so much for your answer!!