Neon

N

Neon

The official Neon Database Discord

Join

šŸ™ļ½œfeedback

ā“ļ½œquestions-and-answers

🐘|postgres

metropolitan-bronze
metropolitan-bronze8/5/2024

hello, i keep getting this error when

hello, i keep getting this error when trying to connect .. it connected at. home but right now I am at the library and it is no longer connectiing .. does anyone have any advice ? Error connecting to PostgreSQL Database: connection to server at xyz.us-east-2.aws.neon.tech port 5432 failed: Operation timed out Is the server running on that host and accepting TCP/IP connections?...
ratty-blush
ratty-blush8/5/2024

conn = _connect(dsn, connection_factory=

conn = _connect(dsn, connection_factory=connection_factory, **kwasync) django.db.utils.OperationalError: connection to server at "ep-billowing-resonance-a54yftck.us-east-2.aws.neon.tech" (3.143.47.40), port 5432 failed: server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request. I got this error when I try to "py manage.py migrate"...
harsh-harlequin
harsh-harlequin8/4/2024

hiya, is there a way to change the owner

hiya, is there a way to change the owner of a database to a different role? trying to run any postgres sql command gives me a permission denied error
robust-apricot
robust-apricot8/2/2024

Hi, I am wondering why the following sql

Hi, I am wondering why the following sql alter table statement is taking over 10 minutes and locking up our db (adding this to a table with 2.7M rows)
ALTER TABLE public.results ADD COLUMN updated_at TIMESTAMP;
ALTER TABLE public.results ADD COLUMN updated_at TIMESTAMP;
...
modern-teal
modern-teal7/18/2024

I’m not using clerk, that’s a different

I’m not using clerk, that’s a different from the other docs.
other-emerald
other-emerald6/27/2024

Is the `DatabaseError` class from `@

Is the DatabaseError class from @neondatabase/serverless the same as PostgresError from the postgres package? Reason I'm asking is because I'm implementing errorhandling, and I want to type narrow the error type that is thrown when violating something like unique constraints forexample
rival-black
rival-black6/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
automatic-azure
automatic-azure6/23/2024

Thread

No description
absent-sapphire
absent-sapphire6/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...
rival-black
rival-black6/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...
correct-apricot
correct-apricot6/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?
blank-aquamarine
blank-aquamarine6/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...
rival-black
rival-black6/16/2024

Any specific guidance on configuring

Any specific guidance on configuring neon as slave for streaming replication?
extended-salmon
extended-salmon6/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
compatible-crimson
compatible-crimson6/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
rival-black
rival-black6/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?
absent-sapphire
absent-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. ...
wise-white
wise-white6/9/2024

Thread

No description
extended-salmon
extended-salmon6/3/2024

does Neon support db snapshots?

does Neon support db snapshots?
ugly-tan
ugly-tan6/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?