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]); ...Pooling question for using Neon with Cloudflare Hyperdrive
I'd like to use Neon with Hyperdrive, but I see conflicting documentation whether to turn on/off Neon's own pooling.
Cloudflare's docs says to turn it off:
https://developers.cloudflare.com/hyperdrive/examples/neon/#:~:text=uncheck%20the%20connection%20pooling
...
not opening table tab
when i am opening my database it is opening but the table tab is not opening a error is coming in that. It was opening a few hour ago but not now and i have not done any changes in my any code
Plz someone help me with this...
How to connect with create/drop database rights?
I see that there is a the neondb / neondb_user created by default.
Is this use an admin user on psql? I mean, how do I connect such that I can create/drop a database?...
P1001: Can't reach database server at `localhost:5432`
Hey, im using Neon and Prisma in my Next.Js project, when i try to push my db for the first time i get this error. i already read foruns and the Prisma and Neon doc, all they say to add a connect_timeout to the URL, i did it and the error persist.
In my .env:
DATABASE_URL="postgresql://mydb_owner:<password>@ep-mute-term-a52thx58-pooler.us-east-2.aws.neon.tech/mydb?sslmode=require&connect_timeout=15&pool_timeout=15"
...
2FA Auth
Hi there 👋
I would love to know when Neon will support 2FA authentication. It feels odd for a database product to not support such a basic security feature nowadays. 🤔
Thank you very much!!...