PG_Restore a sample DB in a tutorial ... you think it would be easy
I installed PostgreSQL on my Mac and did a simple test, creating a database and assigning a user with roles. I thought to look for a tutorial using a sample database and found this tutorial ... https://neon.tech/postgresql/postgresql-getting-started/postgresql-sample-database
I downloaded the DVD Rental Sample Database and noted it was gzipped .. so I unzipped and made a tarball (per the instructions). All was going well. I was ready to use pg_restore.
From the command line. I tried to run pg_restore and get the error "error: could not find header for file "toc.dat" in tar archive". I verified it is in the tarball. ...
From the command line. I tried to run pg_restore and get the error "error: could not find header for file "toc.dat" in tar archive". I verified it is in the tarball. ...
Avoid using main
There is something I'm super worried about:
When I log in to the Neon console and create a new branch to test out some schema changes, it seems very, very easy to make those schema changes to the main branch.
Is there any way of avoiding this?...
mcp local server without specific client failed with keyv error
Hello, I want to test Neon MCP locally with my Python Anthropic agent.
I have installed the package:
npm install -g @neondatabase/mcp-server-neon
and then simply run it via: npx -y @neondatabase/mcp-server-neon start <YOUR_NEON_API_KEY>
I get the following errors:...Subscribed via AWS Marketplace, but can't figure out how to access the paid plan
I pitched my team on migrating some projects from RDS to Neon. Being an AWS shop, our administrator found Neon in the AWS Marketplace and subscribed to the scale plan. The subscription shows up in our contacts and shows as active, but we can't figure out how to access the plan.
I understand this isn't "official" support, but we can't figure out how to access the paid plan, so we can't submit an actual ticket....
Timescaledb compression storage
Hello! Im looking to run timescaledb on neondb, it performs very well on other engines and i wanna continue using it!
On timescale, specially on timescale cloud, there's a way to add an external storage for it to save old records on a cold storage, where it can access if requested through a query. If i recall correctly its called tiered data.
Does neondb + timescaledb supports such thing?...
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...