Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

foreign-sapphire
foreign-sapphire6/25/2024

Hmm how does Neon perform with

Hmm how does Neon perform with transactions? Just added a Pooled connections with my Drizzle ORM. Basically the transaction performs 500 inserts in to 1 table, and the result of the main ID is used to create related records that is usually 1 -> 1.2 in relation ratio. but each batch with related data transactions takes about 40-50 seconds to insert. (using Drizzle ORM) R and W comes from the same Neon DB instance
optimistic-gold
optimistic-gold6/23/2024

Thread

No description
fair-rose
fair-rose6/22/2024

npx prisma db push

npx prisma db push Environment variables loaded from .env Prisma schema loaded from prisma/schema.prisma Datasource "db": PostgreSQL database "mydb", schema "public" at "localhost:5432". why did this error keep coming up...
fascinating-indigo
fascinating-indigo6/19/2024

Hello,

Hello, I'm attempting to connect NeonDB to the PgBouncer Docker image (edoburu/pgbouncer). However, when I try to connect using pgAdmin, I encounter the following error: Unable to connect to server: connection failed: FATAL: 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...
quickest-silver
quickest-silver6/18/2024

my instance was in the europe region.

my instance was in the europe region. Also are there any plans to have london as a region?
wise-white
wise-white6/18/2024

Asia Pacific Region Down

Hey folks, The Asia Pacific (Singapore) region is currently experiencing issues. Really sorry about that. The team is looking into it. You can follow the progress on the Neon status page https://neonstatus.com/aws-asia-pacific-singapore @Linked @Kabir Asani @한솔 (hsol) @martin-full-stack...
conscious-sapphire
conscious-sapphire6/16/2024

Any specific guidance on configuring

Any specific guidance on configuring neon as slave for streaming replication?
foreign-sapphire
foreign-sapphire6/16/2024

how do you get the backup of your

how do you get the backup of your postgre database right from your console without using CLI
conscious-sapphire
conscious-sapphire6/16/2024

@harshgoyal3823 , If you are using free

@harshgoyal3823 , If you are using free tier of NeonDB then it downscales itself in five minutes, That's why it might not be working for you, Consider it like that if you are not using your database for five minutes then your machine gets shutdown and you again have to connect to database
rare-sapphire
rare-sapphire6/14/2024

Hello!, i have a question, in the free

Hello!, i have a question, in the free instance is there a time limit in which the database is deleted after that or is it unlimited?
rare-sapphire
rare-sapphire6/9/2024

Hi everyone,

Hi everyone, I need help to set a sequence value. I use the following query to list sequences in the database and it works returning the list of available sequences on the database. ...
rare-sapphire
rare-sapphire6/9/2024

Thread

No description
rare-sapphire
rare-sapphire6/3/2024

does Neon support db snapshots?

does Neon support db snapshots?
extended-salmon
extended-salmon6/3/2024

I'm running into an issue connecting to

I'm running into an issue connecting to a Postgres database hosted in Google Cloud SQL using the @neondatabase/serverless driver. It looks like it's timing out but the same connection details work when I use the pg CLI tooling. Any advice?
generous-apricot
generous-apricot5/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.
...
rival-black
rival-black5/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 ?...
absent-sapphire
absent-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:...
rare-sapphire
rare-sapphire5/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
unwilling-turquoise
unwilling-turquoise5/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?
foreign-sapphire
foreign-sapphire5/21/2024

does neon tech support pg notify?

does neon tech support pg notify?