Issue with storing multiline text with newlines in PostgreSQL
Hello Neon Support Team,
I am experiencing an issue when trying to store multiline text containing newline characters (\n) in a TEXT column in my PostgreSQL database hosted on Neon.tech.
I perform an UPDATE query like this:...
Neon Local fails with HTTP 412 on reveal_password API for default role
I'm using Neon Local via Docker and encountered an issue where the container fails to start due to a 412 error when calling the
reveal_password API for a role like hibohiboo66+hasura.
The error output is:
requests.exceptions.HTTPError: 412 Client Error: Precondition Failed for url: https://console.neon.tech/api/v2/projects/......Does the Neon UI not support >200 projects?
Hi, I think we have >400 projects but the Neon console seems to only show 200. Is that right?
Error: Schema engine error:ERROR: Your account or project has exceeded the compute time quota. Upgr
On the free plan - just created an account a few days ago - around 10. I've been using neon for a previous project and never hit the free usage quota for compute time - but for some reason I have this time. I'm not sure if its an error on my side or on Neon's side - really confusing how I'd have used it all up. But because it's the free tier I can't diagnose why as don't have access to the logs. Is there anything else i can look at?
Hey, wondering if it is possible to reset the password associated with my db connection?
Hey, I have a postgres db running via vercel and my connection string (containing the password) got sent via email.
Just wondering if I can change the password and how?...
Update Next.js production branch without interruption
When applying a migration to the production branch, there's a lag between when the database is updated and when the new production version is live. What is the best way to avoid this lag?
Usage Monitoring - Alerts?
Hi! I'm currently prototyping a few projects using neon free tier. I will be doing some relatively large tests (up to 1000 users) before launch and want to get alerts about usage, ideally 1. usage spikes/anomalies, as well as 2. reaching the limits (lets say 80% used?) so I can catch the moment I would need to upgrade to paid (if that comes)
Neon Vercel integration
I have enabled Neon vercel integration to allow automatic creation of database branches upon vercel preview deployments. I have a staging env in vercel as well. Will the branches be created automatically when I deploy to vercel staging env as well or its only for preview specifically?
How are the metrics calculated?
Hello,
I'm checking the metrics dashboard and I see a spike in the number of insert operations. For sure, I know from the codebase that we are not making those many requests.
Is it possible that the number of insert operations shown on the metrics also include number of select operations?...
Impact of 'Long Forks' in Neon?
Hi, I was just reading the recent Jepsen report: https://jepsen.io/analyses/amazon-rds-for-postgresql-17.4 - it turns out he stumbled across an issue that has been known for quite a few years described as 'Long Fork' behaviour, and looking at the Postgres mailing list thread on the proposed patch for CSN Snapshots I can see that Neon was already investing energy to improve the situation well before the recent buzz (Heikki works for Neon). It seems that patch won't be included in Postgres 18, unless I'm missing another thread(?)
In the meantime though, does the advice in the AWS response to the Jepsen report hold for Neon also? Specifically "Applications should never rely on the implicit commit ordering of independent concurrent transactions". Or does Neon somehow otherwise ensure that all compute nodes observe the same transaction orderings (even for read-only transactions)?...
can I change plan mid month
Hey can I change plan mid month, like if I start with the lauch plan but we find that autoscalling to 4cu is limiting us can we upgrade to scale plan mid month for the 8cu autoscaling?
Private networking on Azure
Hello, is there an option with Neon on Azure not to connect through public net as there is on AWS (https://neon.tech/docs/guides/neon-private-networking) ? I was really looking forward to full Azure integration, but if the only way how to protect the Neon service from the outside world is by IP based whitelisting, service still being exposed and connection going unprotected, it is not usable for my governmental use case.
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.