Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

blank-aquamarine
blank-aquamarine5/31/2024

hi, i am on the neon free tier. i have

hi, i am on the neon free tier. i have three branches. one of the branches has started returning this
psql: error: connection to server at "<redacted>.us-east-2.aws.neon.tech" (<redacted>), port 5432 failed: ERROR: Console request failed: endpoint is temporarily unavailable. Check your quotas and/or contact our support.
psql: error: connection to server at "<redacted>.us-east-2.aws.neon.tech" (<redacted>), port 5432 failed: ERROR: Console request failed: endpoint is temporarily unavailable. Check your quotas and/or contact our support.
...
funny-blue
funny-blue5/28/2024

Hello, when I want to connect my NEON

Hello, when I want to connect my NEON postgresql database I get an error Error: P1001: Can't reach database server at ep-square-glade-a5075h20-pooler.us-east-2.aws.neon.tech:5432 but RENDER connects me well. Can someone help me please ?...
conscious-sapphire
conscious-sapphire5/28/2024

hello!

hello! just discover the neon platform, i've already setup everything in my account, it is starter account to learn and see if this will work for me. i'm trying to connect to the database using python and using the documentation, but every time i receive this error using python, node, pgadmin, anything that i've tried, same error:...
vicious-gold
vicious-gold5/24/2024

I'm currently using Knex to execute

I'm currently using Knex to execute queries against Neon. I'm noticing that sometimes, it takes almost half a second to release a connection back to the pool. Deos anyone know if this is related to Neon at all?
No description
frail-apricot
frail-apricot5/21/2024

What does `select 100 * (sum(idx_blks_

What does select 100 * (sum(idx_blks_hit) - sum(idx_blks_read)) / sum(idx_blks_hit) as index_hit_rate FROM pg_statio_user_indexes; show?
unwilling-turquoise
unwilling-turquoise5/21/2024

does neon tech support pg notify?

does neon tech support pg notify?
complex-teal
complex-teal5/21/2024

guys im using the pgvector extension and

guys im using the pgvector extension and am about to onboard a large client with 10.000s of files. So far I've only had to deal with 100s of files and 10.000s of chunks. Will I know have to worry about partitioning etc or does neon.tech do some magic for me handling this number of files/chunks? And if not timescale seems to claim some major scalability benefits. Would they be a better vendor?
genetic-orange
genetic-orange5/20/2024

Connect to Data Studio / Looker Studio

I'm trying to connect a neon database to looker studio and I keep getting an error, even after following the guide here: https://community.neon.tech/t/connect-to-data-studio-looker-studio/299
evident-indigo
evident-indigo5/9/2024

Error: P1001: Can't reach database

Error: P1001: Can't reach database server at ep-steep-frost-a2ezhfno-pooler.eu-central-1.aws.neon.tech:5432
Please make sure your database server is running at ep-steep-frost-a2ezhfno-pooler.eu-central-1.aws.neon.tech:5432....
rising-crimson
rising-crimson5/9/2024

I am using Neon Tech on my NextJS +

I am using Neon Tech on my NextJS + Prisma Project. In local I can get the results but after deploying it in vercel i am not able to get results from Neon. It is returning below error. Can anyone suggest some way ?? TypeError: Failed to parse URL from undefineduser/login...
eastern-cyan
eastern-cyan5/8/2024

I know Front-end and trying to build a

I know Front-end and trying to build a webapp which uses postgres as backend, how to do I set up a Neon server for online postgres database? Neon gave me a long link I dont know where to paste it...Would appreciate if someone can help me with setting up the DB and taking it online, thanks!
genetic-orange
genetic-orange4/26/2024

Possible to restore a deleted database?

Hello, Is it possible to restore database once deleted through console?
passive-yellow
passive-yellow4/22/2024

Nested Transactions Thread

Oh, you mentioned a ws library, so I guess you will be using the websocket-based one
other-emerald
other-emerald4/17/2024

Cache Hit Rate

Hello, I'm testing Neon to replace heroku postgres. Everything is working great, except the buffer hit rate. On Heroku, I have a 100% hit rate...
conscious-sapphire
conscious-sapphire4/7/2024

Both seem to be default 4.

Both seem to be default 4.
other-emerald
other-emerald2/29/2024

Make varcache (the pg parameters cached ...

👋 hello friends, I'm wondering how to take pg_dumps of my (pooled) db. There are lots of warnings on Neon saying it will break things, but this merged PR seems to fix that (maybe?) https://github.com/pgbouncer/pgbouncer/pull/867 Do we know what version of pgbouncer Neon uses?...
extended-salmon
extended-salmon2/18/2024

@Vadim Kharitonov Per Github, let me

@Vadim Kharitonov Per Github, let me know if you want to talk about replication...
conscious-sapphire
conscious-sapphire2/12/2024

Column from Integer to UUID

I was trying to change the integer type to UUid but it didn't change. What steps to follow
frail-apricot
frail-apricot2/7/2024

How long does the same query take to

How long does the same query take to execute in the SQL Editor in the Neon console? You can see the time in the bottom right corner. If it's also slow in the SQL Editor, tTry using the Analyze button to debug why. Maybe try using a larger compute size too. You might be using the default scaling that starts of 0.25 CPU...
No description
frail-apricot
frail-apricot2/2/2024

Can you share the error and schema?

Can you share the error and schema? Usually something sensible like a serial type is fine: https://github.com/evanshortiss/vercel-neon-drizzle-next/blob/main/src/db/schema.ts#L4