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.

Hello! I can connect to remote postgresql database in heroku when I run the code locally by using “netlify dev” but it doesn not work when I deploy it in netlify. I tried to use “import pg from “pg”;” I got this solution from node.js - “Error: Please install pg package manually” when trying to ru…

@shavkatsh Are you aware that heroku and Netlify are not equivalent environments? See: [image] [Support Guide] Can I run a web server, HTTP listener, and/or database at Netlify? Support Guides Last reviewed: July 2025 How do I run a server/database at Netlif…

I am NOT trying to run any database or server in Netlify. My database is hosted by Heroku. Heroku provides the url that I use to connect to the postgresql database in Heroku remotely. My little test web app can be hosted by either my local machine OR by Netlify site, it is static JS/React code, it…

[image] shavkatsh: But when I deploy the exactly same test app and run it in netlify site it cannot use “sequelize” with remote Heroky database. Why? I’ve got no idea. Sorry I’d misread your your initial sentence and was just ensuring your weren’t trying to transfer a project from heroku ov…

No problem! I haven’t seen this article, I should read it and try what they suggest. Thank you for this link!

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
Cannot connect to postgreSQL database Support netlify-newbie , database	16	4943	September 11, 2024
Cannot Find Module during deployment Support deployment	2	474	June 2, 2024
Postgres libpq dependencies failing on deploy Support deployment , lambda-functions , netlify-newbie	4	999	April 27, 2023
Mysql2 not found in Netlify functions Support lambda-functions	3	761	September 15, 2023
Continues deployment of functions with postgresql Support deployment , lambda-functions , netlify-cli	28	3778	October 30, 2021

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

Related topics