Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

exotic-emerald
exotic-emerald5/27/2024

'notification' event

How can I achieve this in neon?
No description
unwilling-turquoise
unwilling-turquoise5/27/2024

Permission error using `pgcopydb clone --follow`

What I get a permission error when I try to run pgcopydb clone --follow to run a continuous migration from my source db in Amazon to my target db in Neon. It looks like the pgcopydb tool cannot create the necessary replication objects on the Neon side using the sales_owner user that I set up in my Neon project. Here is the relevant part of the error message (I will reply with rest of the error): ``` permission denied for function pg_replication_origin_oid...
stormy-gold
stormy-gold5/27/2024

not able to fetch and mutate the data

Hi all, I am trying to use this code ```typescript export default async function Page(formData: FormData) {...
No description
exotic-emerald
exotic-emerald5/26/2024

Tables Bug?

BIGINT are not displayed correctly in your Tables website tool. For example, it simply turns 72057594037963085 into 72057594037963090. The problem runs right through the database, but it only does this with long IDs, short ones are spared. I have also compared rows with the correct DB where everything is stored correctly but is only displayed incorrectly in your UI. Seems like IDs are rounded... Btw you can filter in tables for the right ID but still will find the wrong one 😄 have a good one:Postgresql_elephant:...
quickest-silver
quickest-silver5/26/2024

can I delete my account without updating my plan?

I'm trying to use this guide: https://neon.tech/docs/introduction/support#standard-support, but I get this message instead (screenshot)
No description
fascinating-indigo
fascinating-indigo5/24/2024

Neon have AWS SA-SAO-PAULO? I need this to contract the service

I need to have the Database Server in the same country i have the backend, i see somewhere Neon have the us-sao-paulo But when i create my free account i dont see this option to select...
absent-sapphire
absent-sapphire5/24/2024

Vercel Integration Not Auto-Creating DIRECT_URL For Each Branch Deployment?

This is preventing me from deploying since DIRECT_URL and DATABASE_URL are different on each branch.
ratty-blush
ratty-blush5/23/2024

Help with migration

Hello, super new to discord, neon, and drizzle. Using drizzle and neon, trying to update the table in neon to add a new column to a table. I updated the schema, and then ran npm run db:generate - successfully created a migration file in my migrations folder "0006_warm_omega_flight.sql". Tried to run npm run db:migrate and got this error: ❌ Migration failed Error: No file migrations/0000_left_romulus.sql found in migrations folder...
deep-jade
deep-jade5/23/2024

How to set up execution timeout?

I wanna avoid this type of hunging operations
No description
harsh-harlequin
harsh-harlequin5/22/2024

EMERGENCY: Production database keeps going down

Our production database keeps going down with
port 5432 failed: ERROR: server login has been failing, try again later (server_login_retry)
port 5432 failed: ERROR: server login has been failing, try again later (server_login_retry)
as an error message. This is a major issue. The only resolution is to manually restart the compute endpoint each time. Other context:...
deep-jade
deep-jade5/22/2024

[Branching Strategy] Do we need to delete the unused branches?

Hi, Just experimenting with the branching feature and wondering if I can keep the branch and reset if when needed or should I delete them when not in use? Also, what's the best strategy for merging/deploying to main. Currently, my migration to prod is a bit tricky. I have two databases: one for prod and one for staging. staging has dummy data....
fascinating-indigo
fascinating-indigo5/21/2024

Managing databases (adding/removing rows)

Sorry for the silly question, I am pretty new. Why I can't add/delete rows in a database on Neon portal? I just wanted to be able to insert/delete new records manually on the portal.....
stormy-gold
stormy-gold5/21/2024

Compute usage different in project dashboard compared to usage metric

In my project dashboard, it says that I've used 2.4 hours of computing, but when checking my usage in billing, it only shows 0.02 / 5 hours. I assume the compute shown in the billing is correct, but I'm just wondering why it says 2.4 hours in the dashboard.
No description
sunny-green
sunny-green5/21/2024

Vercel deployments are failing due to Neon Branching check

After enabling the Vercel & Neon integration all my deployments through the Vercel CLI are failing due to the Non branching check. The only log I can find is the one in the picture ("Status not available"). However, from the neon side it looks like the preview branches are being created. Please help.
No description
deep-jade
deep-jade5/21/2024

Unable to query DB

Hi I am getting this error: request failed: endpoint is temporarily unavailable. Check your quotas and/or contact our support...
eastern-cyan
eastern-cyan5/20/2024

I can't established a new connection to my database...

I have to create a food delivery web application like uber eats. So to do that, I created a database with random values for each tables and I configured each tables. Now I wanted to make the security of my application (authentification...) but when I create a new connection to my database using Intellij it created a new database. I don't understand why because I filled in all the necessary information. Does anyone have a solution?...
adverse-sapphire
adverse-sapphire5/20/2024

How can I reset my password?

How can I reset my password? I can't find a way to reset my password on the website. Thank you very much...
correct-apricot
correct-apricot5/20/2024

Connection string has changed and can't access database on neon dashboard.

Hello, I tried to creat a new account on neon.tech with my different email but it was actually connected to my first account which was created with my github account, so it overwrote my database and all the tables are wiped on the dashboard. However, I can still connect my app to the first database using the original connectionstring. I am using prisma studio so I can see the table items using their service, but I cannot see my table contents via neon.tech. Could anyone help me with this?...
optimistic-gold
optimistic-gold5/19/2024

How is the storage size calculated?

As you can see in the screenshot: I have transferred 28 KB and the storage size became 29 MB. It seems to be a very inefficient way to store something.
No description
eager-peach
eager-peach5/18/2024

Neon + Prisma + Next Middleware Runtime Issue

Hey! I am running into a tricky situation using Neon with Prisma + Next + NextAuth, which causes the following error when trying to load my application: A Node.js API is used (process.cwd) which is not supported in the Edge Runtime. This error is a result of: 1) The Prisma + Neon client config requires adding dotenv.config(); for the Pooler, which uses process.cwd internally 2) To configure NextAuth, I rely on the Prisma client in my Next middleware.ts , which is on the Edge Runtime. ...