# N8n isn't accepting my PostgreSQL configuration

**URL:** <https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467>\
**Category:** Questions\
**Tags:** database\
**Created:** [May 12, 2026, 10:27pm UTC](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467 "2026-05-12T22:27:54Z")\
**Posts on this page:** 8\
**Page:** 1

<div class="post-metadata">

**Author:** ![Mr\_Kintu](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mr_kintu/32/173578_2.png) [@Mr\_Kintu](https://community.n8n.io/u/Mr_Kintu)\
**Post date:** [May 12, 2026, 10:27pm UTC](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467/1 "2026-05-12T22:27:54Z")

</div>

have configured my .env file to use PostgreSQL instead of SQLite3:

DB\_TYPE=postgresdb  
DB\_POSTGRESDB\_HOST=localhost  
DB\_POSTGRESDB\_PORT=5432  
DB\_POSTGRESDB\_DATABASE=n8n  
DB\_POSTGRESDB\_USER=  
DB\_POSTGRESDB\_PASSWORD=

# **User Management DB (must match main DB unless intentionally separate)**

N8N\_USER\_MANAGEMENT\_POSTGRESDB\_HOST=localhost  
N8N\_USER\_MANAGEMENT\_POSTGRESDB\_PORT=5432  
N8N\_USER\_MANAGEMENT\_POSTGRESDB\_DATABASE=n8n  
N8N\_USER\_MANAGEMENT\_POSTGRESDB\_USER=  
N8N\_USER\_MANAGEMENT\_POSTGRESDB\_PASSWORD=

But I keep facing this error when trying to set up my local Ollama models:  
Error in chat execution: Error: Could not locate the bindings file. Tried:  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\build\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\build\Debug\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\build\Release\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\out\Debug\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\Debug\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\out\Release\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\Release\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\build\default\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\compiled\24.15.0\win32\x64\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\addon-build\release\install-root\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\addon-build\debug\install-root\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\addon-build\default\install-root\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\lib\binding\node-v137-win32-x64\node\_sqlite3.node  
Title generation failed: Error: Could not locate the bindings file. Tried:  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\build\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\build\Debug\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\build\Release\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\out\Debug\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\Debug\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\out\Release\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\Release\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\build\default\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\compiled\24.15.0\win32\x64\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\addon-build\release\install-root\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\addon-build\debug\install-root\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\addon-build\default\install-root\node\_sqlite3.node  
 → C:\Users\d-kin\AppData\Roaming\npm\node\_modules\n8n\node\_modules\sqlite3\lib\binding\node-v137-win32-x64\node\_sqlite3.node

I am using Node v24.15.0, npm v11.12.1 and n8n v2.20.0

Could someone please help me understand why this is happening?

 ![591341103-19dbfb1f-4474-4164-92b7-c622fb794f2f](https://europe1.discourse-cdn.com/n8n/original/3X/f/c/fc1d0013a169d3a3ccbcf46503c0fbb7de00937f.jpeg)

---

<div class="post-metadata">

**Author:** ![kjooleng](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/kjooleng/32/184045_2.png) [@kjooleng](https://community.n8n.io/u/kjooleng)\
**Post date:** [May 13, 2026, 1:46am UTC](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467/3 "2026-05-13T01:46:53Z")

</div>

Hi 👋@Mr_Kintu

**AI Agent nodes require sqlite3** even when using PostgreSQL. The error likely occurs because the sqlite3 package wasn’t properly compiled for your Node.js version. **Node v24.15.0** has known compatibility issues with sqlite3 bindings.

The pre-built binaries don’t exist yet for Node 24, so you need to rebuild them manually using below commands

```bash
# Install Windows build tools
npm install --global windows-build-tools

# Then rebuild sqlite3
npm rebuild sqlite3

# Or reinstall n8n completely
npm uninstall -g n8n
npm install -g n8n

```

You can also consider downgrading to Node.js LTS (v20 or v22) which has better compatibility

```bash
# Using nvm (Node Version Manager)
nvm install 20
nvm use 20

# Then reinstall n8n
npm install -g n8n

```

Does that help?

---

<div class="post-metadata">

**Author:** ![nguyenthieutoan](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/nguyenthieutoan/32/120924_2.png) [@nguyenthieutoan](https://community.n8n.io/u/nguyenthieutoan)\
**Post date:** [May 13, 2026, 8:33am UTC](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467/4 "2026-05-13T08:33:51Z")

</div>

Welcome to the community, @Mr_Kintu! And good catch from @kjooleng on the Node.js version.

To explain why this happens: the error `Could not locate the bindings file` for sqlite3 is a **native module compatibility issue**. The sqlite3 npm package bundles pre-compiled native binaries for specific Node.js versions. Node v24 is very new and the prebuilt binaries included in n8n’s dependencies may not have been compiled for it yet.

Here’s the thing: even though you’ve set `DB_TYPE=postgresdb`, n8n still has sqlite3 as a dependency in its package tree (it’s used internally for some fallback paths and gets loaded at startup regardless of your DB config). If the sqlite3 native binary can’t load for your Node version, it throws that error and n8n can’t start at all.

**The fix:** Use Node.js 20 LTS (the officially supported version for n8n). With nvm:

```auto
nvm install 20
nvm use 20
nvm alias default 20
npm install -g n8n

```

Node 18 LTS also works. Both are officially supported. Node 22 may work in some cases but 24 is not yet tested/supported as of n8n v2.20.

Once you’re on Node 20, your PostgreSQL config should be picked up correctly.

---

<div class="post-metadata">

**Author:** ![tamy.santos](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/tamy.santos/32/153776_2.png) [@tamy.santos](https://community.n8n.io/u/tamy.santos)\
**Post date:** [May 13, 2026, 12:53pm UTC](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467/5 "2026-05-13T12:53:50Z")

</div>

welcome to the n8n community @Mr_Kintu

One extra thing I would check after switching away from Node 24 is whether n8n is actually loading your .env values. Also, I would not leave DB\_POSTGRESDB\_USER and DB\_POSTGRESDB\_PASSWORD empty. Create a real PostgreSQL user, confirm the n8n database exists, then restart n8n completely. As a simpler workaround, Docker Compose with PostgreSQL may be more predictable than npm on Windows.

---

<div class="post-metadata">

**Author:** ![Mr\_Kintu](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mr_kintu/32/173578_2.png) [@Mr\_Kintu](https://community.n8n.io/u/Mr_Kintu)\
**Post date:** [May 13, 2026, 1:09pm UTC](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467/6 "2026-05-13T13:09:31Z")

</div>

Thanks @kjooleng, I’ll try downgrading to node v22/v20 and use windows-build-tools to install the package! I’ll let you know how it goes

---

<div class="post-metadata">

**Author:** ![Mr\_Kintu](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mr_kintu/32/173578_2.png) [@Mr\_Kintu](https://community.n8n.io/u/Mr_Kintu)\
**Post date:** [May 13, 2026, 1:11pm UTC](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467/7 "2026-05-13T13:11:19Z")

</div>

@tamy.santos oh no, those variable fields are real! It’s the binding issue that has been doing my head in. But thanks for sharing!

---

<div class="post-metadata">

**Author:** ![Mr\_Kintu](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/mr_kintu/32/173578_2.png) [@Mr\_Kintu](https://community.n8n.io/u/Mr_Kintu)\
**Post date:** [May 13, 2026, 1:12pm UTC](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467/8 "2026-05-13T13:12:26Z")

</div>

Thanks for this, @nguyenthieutoan & @kjooleng! Let me try these improvements out & return to you.

---

<div class="post-metadata">

**Author:** ![system](https://dub1.discourse-cdn.com/n8n/user_avatar/community.n8n.io/system/32/195824_2.png) [@system](https://community.n8n.io/u/system)\
**Post date:** [August 11, 2026, 1:13pm UTC](https://community.n8n.io/t/n8n-isnt-accepting-my-postgresql-configuration/295467/9 "2026-08-11T13:13:18Z")

</div>

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.