Is it possible to see the table schema in Neon console?
I'd like to see the column types, foreign constraints, etc.
ALTER TABLE ADD CONSTRAINT fails with "No space left on device" error
Query: ALTER TABLE "<table>" ADD CONSTRAINT "<key>" PRIMARY KEY (<column_1>, <column_2>);
Error: PANIC: could not write to file "pg_wal/xlogtemp.524": No space left on device (SQLSTATE 53100)
I am trying to migrate my database from another PostgreSQL provider to Neon using a documented method (pg_dump + pg_restore), but I got stuck on this issue. The first time this error occurred was during pg_restore. After pg_restore finished (with only this error), I tried to run the following query again by connecting to the database via psql (unfortunately with the same error) and then in Neon SQL Editor, but with the same error.
...
Neon / Vercel integration broken this morning?
My git branches aren't getting their normal branched DBs, and it's causing all newly created preview deployments to fail.
Error: Error connecting to database: fetch failed (next.js)
At first I thought the problem is with drizzle but the sql function causes the same error as drizzle, I'm using the @neondatabase/serverless package from my next.js app, I've tried both http and websocket connection but nothing worked.
Urgent Bug: Modifying the suspend interval is not permitted on this account
Hi guys, we are an enterprise customer of yours and I already tried reaching out via slack, but since its urgent I also will try it here:
Since a couple of days I'm
getting modifying the suspend interval is not permitted on this account when trying to create a new neon project.
It only starts working when removing the SuspendTimeoutSeconds: setting, but then fails with the next error saying we are not allow to create projects with IP allow lists. But this exact configuration was working for the past months on production and we just cannot create projects without ip allow lists.
I'm guessing our account is misconfigured on your end because according to your pricing table we should be able to do both of these things with an enterprise account.
I'll dm you our account details and am grateful for any and all help because this is currently impacting production...Why is `bufferutil` and `ws` needed on my Next.js application?
Hello, a noob here,
I have Next.js with Drizzle ORM. Based on Drizzle's documentation and Neon’s Next.js documentation, all I had to install as a dependency is
@neondatabase/serverless (setting aside Drizzle ORM's set of dependencies).
Then, when I ran the development server and made a query, I got a log message saying "WebSocket is not supported" (I am not sure, but it was along those lines). So I installed the package ws based on a post I saw here (or was it on Reddit?). Then, when I ran it again, it said bufferutil.Mask is missing. So, I went ahead and installed it too, and then it finally worked....Connection Pooling limit question
Hello everyone,
I use connection pooling in my nextjs application. But there's something I'm having trouble understanding. In the documentation, it says that the connection limit in a pool is 64.
However, my nextjs application uses (among other db operations) a middleware for authentication that checks against the database....
Multi-tenant database VS single-tenant databases under shared compute
We currently use a large multi-tenant database and are considering switching to tenant-specific databases. Beyond data separation, are there any performance differences between one large multi-tenant database on a single compute VS using isolated single-tenant databases on shared compute?
Error.captureStackTrace
I got error "Error.captureStackTrace is not a function" on the Neon console (console.neon.tech). This prevents me to see the dev db. Any ideas?
Endpoint ID is not specified!!!
Hi all!
I need help connecting to neon db from my laravel project please 😢
I'm facing this error:
SQLSTATE[08006] [7] ERROR: Endpoint ID is not specified. Either please upgrade the postgres client library (libpq) for SNI support or pass the endpoint ID (first part of the domain name) as a parameter: '?options=endpoint%3D<endpoint-id>'. See more at https://neon.tech/sni...
Strange timeouts on Vercel
I'm connecting to Neon from Vercel Serverless Functions with
@neondatabase/serverless and drizzle-orm/neon-http I get strange timeouts:
```
error saving to db when updating conversation NeonDbError: Error connecting to database: fetch failed
at execute (/var/task/apps/web/.next/server/chunks/375.js:53:7255)...Unable to create event trigger on branch, "permission denied" using `owner` role
Attempting to use pgroll to manage migrations in a zero-downtime fashion, which requires setting up some schema-infrastructure which involves creating an event trigger.
When on a fresh branch from main with the
owner role, I'm unable to run the initialization process:
```
$ pgroll init --postgres-url ......How to separate local development on branch X from a remote preview URL for same branch X?
What's the recommended workflow to separate data between a remote preview Vercel URL (e.g. for
my-feature branch) and local development on the same branch?
When I push the my-feature branch, the Vercel integration would create the branch in Neon, which is great. But, while someone is testing this branch and messing with the data, I'd like to continue developing locally on this branch and make sure that I'm not touching that Neon branch that's being tested....Please allow list of branches to be passed into delete branch Github action
https://github.com/neondatabase/delete-branch-action/tree/main
it would be great if we could also pass in an array of branches to delete, instead of just 1...
Please allow parameter for setting compute size in github action create branch
https://github.com/neondatabase/create-branch-action/blob/main/action.yml
there is currently only the option to define the suspend timeout value. It'd be great if we could also define the compute size of the branch...
Creating Neon branches using Vercel integration
I created a Pull Request, and can see a preview branch was created in Neon.
However, I can't see the Neon branch URL in the Pull Request comments.
I thought the Vercel integration was supposed to add the comment automatically 🤔...
Size of my DB increasing without adding data
Hello. I'm very newbie at Neon. I've a large database and I haven't added new data from some days ago but I've noticed that the data size is actually increasing very fast (more than 1 mb/hour). I've seen at Neon monitoring that periodically rows are updated and every row update get a DB increase. But no new data are been added to my DB, so I don't understand why those row updates increasing the data size. Do you know anyway to solve this, please? Thanks in advance.
Being charged for plan that I don't see within my Account.
I'm being charged for the Launch plan but I don't see that within my account. Would you be able to please cancel the subscription.
Invoice: DFEHNE-00017...
Forgot to downgrade account with 0 usage
Would it be possible to get a refund? I accidentally left a account on the launch plan with 0 usage :( Thanks!
Charged 19 USD for unknown account??
Hi y’all! So frustrating issue. I have no idea which email or account was used to justify charging me 19 bucks again for a service I don’t use, but I would like it reversed. I don’t have any idea which email was used, but in a more private conversation I can provide the last 4 digits of the CC.