does anyone here work for neon? i need help with aws subscription
i purchased a subscription via aws and sent an email to support on monday but haven't heard back, can i talk to someone here about it?
Db & Schema owner unable to GRANT SELECT on 1 schema while another in same db works
Anyone know why GRANTing all table access to 1 schema would fail while succeeding for another schema in the same db? This failure happens when run as the database owner (either from Atlas or from the Neon SQL Editor). This is the code, run right after creating role 'datamart_pg_reader':
```GRANT USAGE ON SCHEMA dm TO datamart_pg_reader;
GRANT USAGE ON SCHEMA plus TO datamart_pg_reader;
REVOKE ALL ON SCHEMA public FROM datamart_pg_reader;
-- does not work, even if changed to SELECT, MAINTAIN:...
-- does not work, even if changed to SELECT, MAINTAIN:...
What is the proper way to connect neon with drizzle orm in next js?
I'm working on an next js application deployed to vercel with drizzle orm - neon postgres
Following the drizzle orm docs I've setup my db as below
```js
import { neon } from "@neondatabase/serverless"
import { config } from "dotenv"...
Prisma Pulse discontinued - realtime alternatives?
With Pulse being discontinued, I'm looking for other solutions that can provide realtime updates for Postgres/Neon. Is there anything else out there that I might've missed?
Export to csv in neon console ui not working
Clicking on "Export all to .csv" doesn't trigger a request / event and nothing happens. It's always worked in the past and we just started experiencing issues March 2, 2025. I've tried with tables in different projects as well as tables with just a few records and still no csv is downloaded. Could you please help?
Diagnose "data transfer quota exceeded" errors
My project has shut down for the month because
Your project has exceeded the data transfer quota.
This is perfectly reasonable. However, I'm not sure what I did to hit 5GB data transfer in 2 days.
I don't see a dashboard to check what queries transferred what amount of data and what IP addresses are involved? There's almost no visibility into the data transfer aspect of things...deleting history
I know I can save the specific history from the query editor but i want to know how can i delete the history in left hand sidebar
pg_dump: Error - could not translate host name to address
I am trying to save my data using pg_dump with my direct connection string like so (in
C:\Program Files\PostgreSQL\17\bin>):
.\pg_dump --schema-only --no-privileges --no-owner "postgresql://postgres:<MY_PASSWORD>@db.blahblahblah.supabase.co:5432/postgres"
I get the error pg_dump: error: could not translate host name "db.blahblahblah.supabase.co" to address: Name or service not known
...JSON data issues with Neon
I recently migrated from Supabase to Neon, and I noticed that any JSON data I fetch from my database has to be parsed, as it is provided as a string. This was not the case with Supabase despite the data types being the same (
jsonb).
Also, whenever I tried editing jsonb within the Table Editor by double clicking, it goes from something like [{"x": 1}, {"y"; 2}] to [[object Object], [object Object]]. Why?...Tables web viewer not supporting sub views for composite foreign keys
When logged into the Tables Viewer/Editor of the Neon dashboard, it seems it is not supporting rendering subviews for composite foreign keys.
For example, if I have two foreign key columns
collection_id and user_key, the subview query only picks up the first column collection_id and compared the wrong value user#xxx to it...
Intermittent errors establishing h2 connection and setting up JWT authorization database extension
Hi, my team is building a NextJS 15 application using Drizzle ORM and Neon RLS Authorize, and we're running into the following two errors intermittently:
...
Error [NeonDbError]: Server error (HTTP status 500): could not establish h2 connection
Error [NeonDbError]: Server error (HTTP status 500): could not establish h2 connection
Error [NeonDbError]: Server error (HTTP status 500): could not set up the JWT authorization database extension
Error [NeonDbError]: Server error (HTTP status 500): could not set up the JWT authorization database extension
Unexpected error happened 😕
"Please download error context and report to our support team", i dont know what causing this error but when i use diffrent wifi it works and not on my wifi
What happens if I got over the monthly data transfer cap?
becuz I have, and we can't get ahold of the account owner to update the payment
Custom JWT with RLS Authorize
I am passing a jwt token to neon with a payload of
```
{
"operator_id": "1",...
Connecting Pool (for Postgres transaction) with Auth Session from Clerk using Drizzle ORM
Hi team,
I have auth sessions setup with Clerk for neon-http so I'm able to leverage RLS policies, however, I'm having a hard time finding any documentation on including the auth session in a Pool Connection which is required for a transaction. Ie. I want to make sure the transaction enforces the RLS policies and has access to the current user session. With neon-http this is simple. db.$withAuth(authToken) solves all my problems, however, this is not clear how it would work in a Pool Connection or a transaction. Any help is much appreciated!...
Supabase + Neon + Neon branching + full postgresql compatiblity. is it possible?
I really want this tech stack, willing to pay and do it on neon cloud. is this possible? the MAIN feature i need is easily to branch in postgresql, also have neon scale-capabilities and serverless sdk, also would like the postgresql FDW feature to work.
want to base my entire backend on it so can one advise?
Thanks!...
migrating from supabase
hi. i'm wanting to migrate from supabase to neon, and i want to ideally do it with a live replica on neon (or some similar setup so i can progressively migrate).
i'm thinking of using neon as a read replica for now with CDC and then moving all writes from neon -> supabase later. is this a valid approach? any advice?...
Neon + Vercel integration + ENV = BUG
Issue with Vercel PostgreSQL and Neon DB Branch Change
I created a PostgreSQL DB on Vercel (managed via the Neon dashboard). After changing the main branch in Neon and deleting the old one, the "automatic environment variable" in Vercel didn't update. It's now stuck on an invalid connection link.
Workaround: I unlinked the DB from the project and manually set the correct environment variable. ...
I created a PostgreSQL DB on Vercel (managed via the Neon dashboard). After changing the main branch in Neon and deleting the old one, the "automatic environment variable" in Vercel didn't update. It's now stuck on an invalid connection link.
Workaround: I unlinked the DB from the project and manually set the correct environment variable. ...
Transient error invoking PGSQL user defined functions from Node backend using 'pg' library.
Has anyone else experienced transient errors invoking a stored function in neon from an external source (pg library in node). Neon throws a 42883 error claiming the function does not exist for a period of several minutes and then returns to normal - with the function executing normally. It doesn't seem to be a parameter type issue as all params are cast to the appropriate types. Here is a sample of the invoking code and of the function definition in Neon - any help is GREATLY appreciated , I am scratching my head.
Invoking code:
result = await client.query(
select geomatch( $1::text , $2::float, $3::float); , [userInput , userLat , userLon]); ...