This code snippet works perfectly locally with netlify dev: const { Sequelize } = require('sequelize'); const sequelize = new Sequelize(process.env.DATABASE_URI); // postgres uri sequelize.create({...}); However, when I deploy this to production, the function logs this error message: {"errorType"…

I have to add this line require('pg') on the top of the file for my production deployment to work. Not sure why this discrepancy exists between production and dev.

Cloud Function Cannot Connect To PostgreSQL With SequelizeJS In Production (Works Locally)

Support

nathanmartin January 19, 2025, 4:05am 4

@shavkatsh Are you aware that heroku and Netlify are not equivalent environments?

See:

Topic		Replies	Views
Continues deployment of functions with postgresql Support deployment , lambda-functions , netlify-cli	28	3609	October 30, 2021
Postgres libpq dependencies failing on deploy Support deployment , lambda-functions , netlify-newbie	4	914	April 27, 2023
Node-postgres failure to build in production deploy Support building , deployment	2	576	February 10, 2023
Cannot connect to postgreSQL database Support netlify-newbie , database	16	4519	September 11, 2024
Mysql2 not found in Netlify functions Support lambda-functions	3	690	September 15, 2023

Cloud Function Cannot Connect To PostgreSQL With SequelizeJS In Production (Works Locally)

Related topics