Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

manual-pink
manual-pink3/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
correct-apricot
correct-apricot3/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?...
conscious-sapphire
conscious-sapphire3/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
adverse-sapphire
adverse-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....
other-emerald
other-emerald3/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

"Please add a primary key column to your table to update or delete rows"

I'm getting the post title as an error message in the Neon web view when trying to edit or delete rows from the "Tables" view. I've never had an issue with this before today. The DB is created from an Elixir Phoenix project. I haven't not changed my DB. Has something in the Neon web view changed that is now causing this error?
foreign-sapphire
foreign-sapphire3/21/2025

Contradictory database

When I try to update one of the rows on my table, it fails because I "should add a primary key". But when I try to alter the table to make one of my fields a primary key, it says "Multiple primary keys are not allowed".
adverse-sapphire
adverse-sapphire3/21/2025

I can't update my tables anymore?

Today, i couldn't update my tables that i used to update very often. I get the error message : please add primary key column to your tables to update or delete new rows?!
ambitious-aqua
ambitious-aqua3/21/2025

Neon on Azure

Is it possible to use azure credits if we provision neon projects via the native integration on azure marketplace?
equal-aqua
equal-aqua3/21/2025

stack auth with vanilla react , how to setup?

Hi, I noticed stack auth has add support for vanilla react, https://docs.stack-auth.com/react/getting-started/setup ,but Neon's auth dashboard only support next.js integration . Will vallina react with stack-auth work with neon? Thanks...
plain-purple
plain-purple3/20/2025

Azure Marketplace Provisioning

I've attempted several variations of deploying from Azure Marketplace. Each attempt in various regions fails to provision the org within neon. SSO and personal account are created; however, I'm presented with the "Org [generated org id] was not found" Order parameters use a hyphen in the desired orgName field, to match our internal corporate naming convention....
rare-sapphire
rare-sapphire3/20/2025

Neon tables in Chrome sometimes reload automatically when I switch tabs in Google Chrome

In Neon Database, every time I switch tabs in Google Chrome, the table reloads the page, causing it to lose its previous state. This issue has been occurring since March 20, 2025.Please advise on how to prevent this from happening?
rising-crimson
rising-crimson3/19/2025

Permission denied to set parameter "sesion_replication_role"

I have a seed script that runs SET session_replication_role = 'replica' to temporarily remove all FK constraints, so I can seed the db without errors. How can I get the permission back? I'm running as neondb_owner. Alternatively, what do you suggest I do instead if I can't have the permission?
fascinating-indigo
fascinating-indigo3/18/2025

update prefix for env vars in vercel

I put the wrong prefix in for the env vars when I first set up the database, and now I can't find a way to update them. Where can I update the prefix?
No description
flat-fuchsia
flat-fuchsia3/18/2025

ST_Distance_Sphere not available even with postgis enabled

postgis version
POSTGIS="3.5.0 d2c3ca4" [EXTENSION] PGSQL="170" GEOS="3.11.1-CAPI-1.17.1" PROJ="9.1.1 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/var/db/postgres/.local/share/proj DATABASE_PATH=/usr/share/proj/proj.db" (compiled against PROJ 9.11.1) LIBXML="2.9.14" LIBJSON="0.16" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)"
POSTGIS="3.5.0 d2c3ca4" [EXTENSION] PGSQL="170" GEOS="3.11.1-CAPI-1.17.1" PROJ="9.1.1 NETWORK_ENABLED=OFF URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/var/db/postgres/.local/share/proj DATABASE_PATH=/usr/share/proj/proj.db" (compiled against PROJ 9.11.1) LIBXML="2.9.14" LIBJSON="0.16" LIBPROTOBUF="1.4.1" WAGYU="0.5.0 (Internal)"
...
flat-fuchsia
flat-fuchsia3/18/2025

Error when creating subscription for replication

Hello, I'm trying to follow a guide for setting up replication between a Postgres database from Supabase into my Neon project database, but I'm getting an error when running the command in Neon to create the subscription. I tried 2 variations and get different errors for each. I'm hoping someone can help me get this working Guide I'm following:...
fascinating-indigo
fascinating-indigo3/16/2025

Can't reach server error

I am making a practo like app and connected neon db from vercel, it was working fine till yesterday, but today as i started the application i am seeing this error I have checked the connection string, also tried adding pooling=true but it's not working...
No description
stormy-gold
stormy-gold3/15/2025

Is there a way to get a diff of two databases

I have a branch of a database which I've made some changes to. Is there a way to quickly determine the diff between the databases?