Error: Cannot resolve "cloudflare:sockets" from "...\node_modules\.pnpm\postgres@3.4.0\node_modules\postgres\cf\polyfills.js" and externals are not allowed!

[cetuuus]

hi,
I'm using Nuxt 3 v3.8, and I'm trying to deploy to cloudflare with the cloudflare preset. But I get the following error:

I've seen that you've already created a fix for this error, but I'm using version 3.4.0 of postgres and the error is still there...

My wrangler.toml file contains the line:

node_compat = true

[porsager]

Any luck with the latest ? (v3.4.3)

[cetuuus]

Doesn't work, same error... You can check de code.

build it with

$env:NITRO_PRESET='cloudflare'; $env:NUXT_JWT_SECRET='djisiu'; $env:DATABASE_URL='postgres://postgres:postgres@localhost:5432/postgres'; pnpm run build

(database is not required for build)

[porsager]

Sorry, but I'm not going to debug why some other build tool doesn't know how to handle this. Create an issue in their repo.

[bllchmbrs]

@dev-cetus , did you figure out how to get this working?

I am trying to run Cloudflare Pages Functions with Nuxt 3.8.2. and this library(postgres(3.4.3) and it fails with the same approximate error during build.

[error] Cannot resolve "cloudflare:sockets" from "/opt/buildhome/repo/node_modules/postgres/cf/polyfills.js" and externals are not allowed!

Pages functions don't support

node_compat = true

or toml files at all. Now you can set nodejs_compat but that doesn't work out of the box.

This issue seems related to:

• Cloudflare pages deployment issue nitrojs/nitro#1679
• fix: ensure that pg-cloudflare can be used with bundlers that don't know about Cloudflare sockets brianc/node-postgres#2978
• [Nitro/Unenv] cloudflare_pages build error: Could not resolve import string_decoder nitrojs/nitro#1821
• Error with postgres@3.4.0 when building for cloudflare nitrojs/nitro#1967

It comes up a lot in this repository.

• Error: dependencies are imported but could not be resolved: cloudflare:sockets #691
• Support for Cloudflare Workers TCP connect()? #598
• Usage in Vercel edge functions #631
• cloudflare:sockets import error #711
• draft: Cloudflare works ! 🎉  #618 - with this one representing success, but I can't figure out how to get it working for my project.

Now this appears to be something related to bundling as @porsager mentions in the various threads (be it webpack, or vite, or whatnot). I just don't know enough about the JS tools to actually debugging - I'm just a user who wants to access a postgres database.

This comment seems like the most thorough on the subject and I'm just hoping that either (a) someone can help resolve this issue, (b) to leave breadcrumbs for others or (c) at least rubber 🦆 my way out of this... Any help appreciated.

[MickL]

Same issue Vercel Edge Functions. This issue is not regarding Cloudflare, but regarding serverless edge workers environments. This project does not work on serverless edge workers. @porsager do you mind reopening this issue?

I wonder why postgres adds this polyfills anyway. If they would be removed and rather be optional the problem might be solved.

[alexcroox]

Did anyone find a workaround in the end? Keen to use Postgres on CF but this polyfill error on build is blocking progress. Thanks!

[minemos]

Any updates?

[Dxuian]

still isnt fixed

[porsager]

Try installing latest from github npm install porsager/postgres

I'll make a release soon if that works fine 😉

[chenrui333]

I just tried npm install porsager/postgres, got this error instead

 ⨯ ./node_modules/.pnpm/postgres@https+++codeload.github.com+porsager+postgres+tar.gz+f58cd4f3affd3e8ce8f53e42799672d86cd2c70b/node_modules/postgres/src/connection.js:1:1
Module not found: Can't resolve 'net'

[porsager]

@chenrui333 what platform are you trying to use it on?

[chenrui333]

I am using vercel edge runtime for the backend. Switch off resolved the issue if that helps.

[porsager]

Yeah. You can't make tcp connections from vercel edge, so Postgres.js won't work there. Neon works because the proxy through websockets.

[johnnyicon]

Found this solution on Stackoverflow, and it worked for me. I'm deploying a Nuxt 3 app to CF Pages.

nitro: {
  preset: 'netlify-edge',
  rollupConfig: {
      external: ['postgres']
  }
}

Source: https://stackoverflow.com/questions/78498288/deploying-nuxt-app-with-postgres-to-cloudflare-fails

Hope it helps!