Neon

N

Neon

The official Neon Database Discord

Join

šŸ™ļ½œfeedback

ā“ļ½œquestions-and-answers

🐘|postgres

noble-gold
noble-gold3/28/2025

Possible to setup neon auth with difference projects and difference branches?

Not entirely sure if this is possible atm and how would I use neon auth for production, staging and local dev separately?
equal-aqua
equal-aqua3/28/2025

Getting password authentication error, while running "node server.js" (new to programming)- while co

"Unable to sync the database: ConnectionError [SequelizeConnectionError]: password authentication failed for user 'neondb_owner'"
conscious-sapphire
conscious-sapphire3/28/2025

terraform-provider-postgresql

Hey, has anyone successfully used https://github.com/cyrilgdn/terraform-provider-postgresql to install extensions, create grants etc? We run into a couple of issues with this on neon. E.g. https://github.com/cyrilgdn/terraform-provider-postgresql/blob/main/postgresql/resource_postgresql_grant.go#L799 this does not really work and throw a permission error.
fascinating-indigo
fascinating-indigo3/28/2025

Database connection error

Hi everyone, I'm building an app using Drizzle and until yesterday everything was fine. But today when I tried to run the app, it was giving me a connection error message on the logs. When I tried to access the console I got the error on the screenshot
No description
sunny-green
sunny-green3/28/2025

Schema-only Vercel preview branching?

Hi Neon Team šŸ‘‹ I’m using Neon with Vercel for a (currently) stealth-mode SaaS startup, making use of the Neon Postgres Previews Integration to create branches for my preview environments. Wondering if you have plans to allow schema-only or anonymised-data automated branching to be configured through the integration as sometimes it’s not appropriate to surface production data outside of production. ...
adverse-sapphire
adverse-sapphire3/27/2025

Issues running migrations with transactions in Laravel

I was really excited to test out Neon and have built a sizable laravel application using Postgres. Unfortunately, I've run into a road block with Neon right out of the gate.
When running migrations it always fails... Strange, works with all the other postgres databases so far.
What I was able to find is migrations coud be run successfully by adding public $withinTransaction = false; to my migration file....
deep-jade
deep-jade3/27/2025

Neon Query Monitor -- does it show only queries from Neon SQL Editor?

If I run a query within Neon (SQL Editor), it shows up in the Query Monitor section under Query History. If I run the same query from an external tool that completes successfully, I see no record of it Query History. I have checked all branches and databases to be sure the external query was going where I expected, and none show any Query History. Also, it seems even when a record shows in Query History, it doesn't last long. If I switch to other branches / dbs and then come back even after...
absent-sapphire
absent-sapphire3/27/2025

Multi-factor Authentication

I’m unable to figure out how to enable two-factor authentication on my Neon account, and I haven’t found any documentation online. Could someone walk me through the steps?
xenial-black
xenial-black3/26/2025

Pricing for Single Project with 1,000 Tenant Databases

Hi Neon Team, I'm evaluating Neon for a multi-tenant SaaS application where we plan to use: - 1 Neon project - 1,000 separate databases (one per tenant)...
robust-apricot
robust-apricot3/25/2025

N8N MCP Client

I am trying to use MCP within n8n but seem to be running into issues. Does anyone have any expereince connecting to n8n. I think it's a credential issue. ``` Command: npx Arguments: -y @neondatabase/mcp-server-neon...
No description
quickest-silver
quickest-silver3/25/2025

Set pg_trgm.similarity_threshold not working?

Hi, Is there a way to permanently set pg_trgm.similarity_threshold from the default 0.3 to 0.5 in Neon? This query does just that in our local db: ALTER SYSTEM SET pg_trgm.similarity_threshold = 0.5 ...
No description
national-gold
national-gold3/24/2025

Can a paid subscription only be paid via AWS or Azure?

Do I need to have a AWS or Azure account to use any of the paid plans?
frozen-sapphire
frozen-sapphire3/24/2025

ERROR: permission denied to set parameter wal_keep_size

Hey everyone! šŸ‘‹ I’m using Neon as the PostgreSQL source for Airbyte (CDC mode), and I’m getting this error: ā€œSaved offset is before replication slot’s confirmed LSN. Please reset the connection, and then increase WAL retentionā€¦ā€...
flat-fuchsia
flat-fuchsia3/23/2025

Can't open Tables using neon console

I've been trying to look in my db from console.neon.tech but whenever I try to open tables it just throw this (attached image) error again and again. I tried different browsers, clearing cookies etc etc. but it doesn't seem to be working, tried with different account and by creating new db too. but still can't do it. need help please šŸ™...
No description
ambitious-aqua
ambitious-aqua3/23/2025

Schema Diff's fail with an error

I have a relatively large db schema and when using the schema-diff tool from either the web console or the command line I get the following error: ERROR: Maximum call stack size exceeded It's not particularly useful, but presume this is happening because of the large schema?...
harsh-harlequin
harsh-harlequin3/23/2025

My Storage is Full even I don't have any data

I have been using neon for almost 4 months for developing my personal project. Currently I am using free tier and planning to upgrade after I deploy my project. But How my storage is getting increasing. I first try to delete the branch now I even delete the project and the stroage still full. I can't work now 🄲
No description
yappiest-sapphire
yappiest-sapphire3/21/2025

Database Connection Error

Hi everyone! I am building an application, and I have a database on NeonDB. For some reason, I'm getting an error in the format Error: P1001: Can't reach database server at ep-white-thunder-826300.us-east-2.aws.neon.tech:5432. I've gone through the docs and done the work arounds, but my database compute is sitting idle as if my application is not able to commuicate with it. Has anybody been through this error before? Can you point me to what parameters I should look out for to fix this error....
vicious-gold
vicious-gold3/21/2025

Missing UUID Primary Keys

Hello! I am new to Neon, but have used PostgreSQL a decent amount. I use UUIDs as primary keys in a few of my tables. However, whenever I create a table in my neon schema (through direct SQL or Neon's UI), it strips my primary key. This is making it impossible for me to remove entries from my tables since the primary keys are being removed from my UUID pkey columns.
fascinating-indigo
fascinating-indigo3/21/2025

When I try to update one of the rows on my table, it fails because I "should add a primary key". But

This has been happening for the past 5ish hours now.