Cancel query
What: I'm trying to cancel a query that's been running for many hours now but with no success.
Why: I'm trying to remove a table trigger but it doesn't complete. I suppose I can't remove a trigger when there's an active query related to it
How: I've tried a few things with no success so far:
1. In Neon's dashboard I click the menu option (Monitoring -> Active Queries -> Query options -> Cancel query) and nothing happens.
2. Tried running "select pg_terminate_backend(PID)" and, although it returns true meaning that the request was received, it doesn't terminate...
Security for Public Neon (Free or Launch tier)
Been reading a lot about neon and am super excited to try to use it for a side project! Was curious on security though, Iād like to use cloudflare workers but traditional advise has been to never expose a database publicly (Iām sure exceptions occur). So was wondering what I should do to secure this. I donāt need to know the secret sauce, but wondering how neon secures databases that are publically available to Ddos attacks.
"internal error" when trying to share Neon integration across two Vercel projects
Trying to add a neon integration into existing project returns internal error. I think it's tied to prefix the database env variables.
Restore more than one day before immediately after upgrading
I accidentally deleted data, and I have the free version and cannot go back one week ago. If I upgrade now, will I be able to go back?
Can I access a Neon DB that was made by Replit? I want to use the instant restore feature
Replit's agent is telling me that it cannot use the instant restore feature because it does not have a Neon API key available to it. I'm waiting for Replit's support but in the meantime all of the content on my site is missing because the database got wiped (by Replit). Is there anyway for me to sign up to Neon directly and access the neon db, given that I have the app secrets that replit uses to connect to neon?
Thanks!...
Help! Hit Branch compute hours limit with minimal usage
I've reached my Neon compute hours limit with just a simple user table (2 rows only). I'm using better-auth to connect to my app hosted on an OVH Ubuntu: https://us.ovhcloud.com/public-cloud/virtual-instances/).
All I'm doing is basic user tracking by using Neon to store my users (account, session, user).
Could my app be keeping connections open constantly? Any tips to reduce usage?...
Reaching free limit with a very small DB
Hi, I'm using free tier with 500 MB limit. My side-project DB 2 has branches (dev which is not used and prod). It has 7 tables where only one is worth mentioning (size-wise) and it also has like 3-4k rows tops amounting to (according to DBeaver) 5.6 MB. Daily "traffic" consists of 100-200 row upserted and 100-200 rows deleted.
But now Neon notifies me that I'm reaching the 500 MB limit.
What does count against this 500 MB limit that might be so large? Indexes - I have very few simple ones, I'd say negligible....
Neon for multi-tenant SaaS clickstream
For a while now i've been looking at alternatives for storing clickstream data and preforming analytics queries on it. We want to simplify our stack and go all-in on postgres and Neon seems to be a good fit for 99% of our use cases. The biggest issue is our clickstream data and analytics.
Our current system cost too much and doesn't scale. We are storing 12 billion clickstream events in a self-hosted Mongodb database (not sharded). That gives us about 6 months of data retention which is not enough. We want to increase the number of events and their payload size and it's just not possible with our current storage. We have about 5-600 customers and 80% of the data/load is generated by a handful of them so we really need better tenant isolation that is hard to do on mongo.
We are debating between making postgress the clickstream store or using something like clickhouse and deal with the complexity of eventual consistency. Like basically everyone, our ideal would be to have the same database for our OLTP and OLAP workloads but i'm not sure we are there yet. I see that Neon support
pg_mooncake (maybe too new and experimental for now) and timescaledb which would probably be enough for most of our users the issue is really the big whales generating millions of events daily and in spikes....Best way to develop Neon + Vercel Edge Middleware
I need to check the database to recalculate the state of the user and route them appropriately. I though of doing this in middleware, only to realize there's a whole other environment that middleware runs on.
I saw that @neondatabase/serverless could support my usecase, but for local (no internet) development I didn't find a good solution....
branches limit exceeded
Hi, I'm getting a "branches limit exceeded" error. I use Neon via Vercel and now only have 1 branch, after having deleted all other shadow branches as well as a separate staging branch on the same project. I also just upgraded to the Launch plan to get more branch capacity. After all of this, I still get the branch limit exceeded message
Vercel fluid, recommended connection strategy from Node.js?
Our team has adopted Vercel fluid compute. We are now in the process of migrating from MongoDB to Neon.
What is the recommended way to connect to Neon from a Node.js application running in serverless fluid functions?
I have found https://github.com/neondatabase/serverless - but is this package optimal for fluid? I would expect TCP to be faster and a better fit?...
Does Listen/Notify work on Neon?
I've written a short test using Node.js and as far as I can tell the answer is no: there is no error, but events are never delivered. Is there some trick to this that I'm missing or does it simply not work at all?
Axiom log support?
In the Monitoring page there is a button "Upgrade to export metrics" with a Datadog logo.
Does the export metrics work with Axiom? I didn't find any info online...
Python-SDK(API) vs CLI-API
hello Neon Team, we have read the following blog post and are wondering if the python-SDK (API) is a full abstraction replacement for the CLI Neon-API ?
If not can we use the python-SDK as a base and complement it with the CLI-API for methods not available on the sdk e.g. quota limits, compute settings etc. ?
https://neon.tech/docs/reference/python-sdk
https://neon.tech/blog/provision-postgres-neon-api...
Neon support seems to be AWOL, what is going on?
I see this forum guideline says "This is not an official support forum, please open a ticket here..." but opening a ticket there under our paid plan is getting us nowhere. It's been days since we entered the ticket, there is no UI to find our outstanding Zendesk tickets, our sales rep has ignored our requests for an update on the ticket, and so, really what is going on over there? This is a 2nd highest priority ticket -- perhaps we have to scream and shout and make everything a top priority to...
Deleting a parent branch
I have a main branch that is sadly the child of two backup branches. i want to delete the backup branches and make main my only branch, with a dev and test child. however, i am unable to delete the parent branches. i see in other comments that you were working on this and i have seen schema only branches, but i need the data to be copied over too. what are my options to get rid of the backup branches please? i just need my main and not the parents.
UNAUTHORIZED (invalid_request)
I connected and was using my MCP server in the VSCode Copilot for 3 days.
Then I saw today '{"error":"Unauthorized"}' here in this link:
https://mcp.neon.tech/sse
...
DB error
Error
at https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/app-CeSRnIR_.js:18:46272
at async https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/DrizzleStudio-pDDTZwOQ.js:1:3122
at async window.drizzle (https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/DrizzleStudio-pDDTZwOQ.js:1:3795)
at async a (https://dfv3qgd2ykmrx.cloudfront.net/assets/assets/load-bundle-BUgT4UiV.js:1210:66475)...
Can't reach database server
Getting this a few times a day
PrismaClientKnownRequestError: Invalid
prisma.user.findUnique() invocation:
Can't reach database server at ep-tight-voice-SERVERID-pooler.us-east-1.aws.neon.tech:5432...Azure data location
I'm in a research step for a client, but one of requirements they have is having all data inside azure, they dont want any data to go outside of azure.
My question is, is this integration only for easier billing or the data hosted in Azure as well ?...