Neon

The official Neon Database Discord

Join

Neon

The official Neon Database Discord

Join

🙏｜feedback

❓｜questions-and-answers

🐘｜postgres

provincial-silver

6/30/2024

Detailed stats about Data Transfer (egress)

Hello, Is it possible to view detailed statistics about Data Transfer on Neon.Tech (either via API or on website). I am on the Free Tier and would like to know which endpoints/databases or tables use most data, so I can get a better understanding and thus being to optimise the usage. Also, egress data, is data that leaves neon.tech (such as db 'reads'), and NOT also data that is coming in (such as 'writes'), is this correct? Thanks in advance....

vicious-gold

6/28/2024

How to see previous months usage??

On the dashboard is "Resources remaining", super helpful for the current month, but how can we see last month's usage? Or the month before? Surely this could be a link on the Resources Remaining panel

exotic-emerald

6/28/2024

subscription stuck between free and enterprise.

I started with a free tier and then moved to launch, but opted to pay through AWS marketplace. I paid for a month and then didn't renew. Now when I visit again the aws marketplace, my existing subscription is no where to be found. Additionally neon still forces me to go to aws market place to manage the subscription, it mentioned the accountId and the entitlementId. What is more neon behaves almost like I am in enterprise plan, there is the enterprise label next to my name, and in dashboard the compute says that it scales up to 8CU. But that is probably not true, since I am bound by the database size, and right now I tried to execute an sql only to get the

[53100] ERROR: could not extend file because project size limit (512 MB) has been exceeded Hint: This limit is defined by neon.max_cluster_size GUC

...

constant-blue

6/28/2024

How to migrate data from neon to local computer

I want to self host postgresql database and I want to know how to migrate from neon to my computer.

sensitive-blue

6/27/2024

It's said I have 500+GB of storage used, while my branches dont exceed 1GB in total !!

extended-salmon

6/27/2024

Integrating with platforms that have dev + prod environments

Hello, I could use help with a question I'm having with using Neon alongside other platforms: We're using a 3rd-party platform to handle authentication. They provide a dev environment and a prod environment. We want to sync some data from the auth provider to our Neon database. For example:...

fair-rose

6/27/2024

I am currently working on a project using nextjs, posstgres+ prisma. I made the database on neon.tec

P1011: Error opening a TLS connection: The message received was unexpected or badly formatted. (os error -2146893018) I tried few things that I found on other stackoverflow/github questions, but it was not helpful: for example appending trustServerCertificate=true; to the DATABASE_URL but the error didn't go away. Today I reinstall my system(macos14.5) now the error didn't go away....

xenogeneic-maroon

6/26/2024

Error: P1001: Can't reach database server at `ep-twilight-river-<Pwd>-pooler.us-east-2.aws.neon.t

Hello I am facing this issue in production. I have already done prisma generate and prisma migrate dev in development server. It is working fine in development server. However, it gives me this error on production server. I am using the following stack with versions: digital ocean droplet as my server, NextJS v14.2.4, ...

metropolitan-bronze

6/26/2024

readonly replica is returning data thats 5 hours old

we have a RW compute and RO compute. we are using nextjs + prisma deployed on vercel. noticed a few errors of records not being found. Narrowed it down to the RO replica not returning data we did a couple of checks and it was only returning data from 5 hours ago. our understanding is that it should read from the same source as the RW so there should be no lag? we are using prismas extends ".$extends( readReplicas({ url: process.env.RO_REPLICA, })...

ambitious-aqua

6/26/2024

Error trying to populate database from a local .sql file

I recently cloned a database locally using the pg_dump command, the file being around 12G. I'm trying to populate this data onto my neon database using the psql command psql <connection string> < database-dump.sql ...

intermediate-olive

6/25/2024

I need to create table with columns named "from" and "to".

Hi guys. I need to create table with columns named "from" and "to". But I get

NeonDbError: syntax error at or near "from"

NeonDbError: syntax error at or near "from"

and when I put in double quotes then I get

NeonDbError: syntax error at or near ")"

NeonDbError: syntax error at or near ")"

Please tell me how I can solve it....

passive-yellow

6/25/2024

3rd Party Services with Preview Branches

I'm looking for some practical advice on how I might tackle integrating 3rd party services (eg. Clerk, Stripe, etc) into branches created for Preview deployments (I'm using the Neon Vercel integration). The problem Branches for preview deployments have been so far great for creating preview deployments that have a copy of all my real production data. And so long as I'm only creating data within my own DB, it also works. However, when data is stored in a 3rd party provider, that data is obviously not copied. This leads to weird data mismatch issues, where I have bits of some production data but not others. ...

harsh-harlequin

6/25/2024

I am unable to connect to my database on localhost

I get no response it just keeps waiting and I finally get TimeoutError

fascinating-indigo

6/24/2024

When will the Tokyo Region be ready?

I have read the neon documentation and it looks great and I would like to use it, but the only bottleneck is that there is no Tokyo region. I would like to use it as soon as the Tokyo region is available......

dependent-tan

6/21/2024

Move Table Data from child branch to parent branch

Hey is there any way to move table data to the parent branch. I want to do this as i want to replicate all data on the dev database to main database...

extended-salmon

6/21/2024

Unable to connect to PGbouncer through NeonDB.

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

...

equal-aqua

6/21/2024

Project has exceeded the data transfer quota

Hello - love the idea of what you're building. Playing around with PoC on the free tier to make sure everything we're going to need can be handled out of Neon. I have a free tier account, and i'm now no longer to perform any operation and am getting the message project has exceeded the data transfer quota informing me I need to upgrade. My issue here, is the observability of said metric is very unclear and quite poor. The dashboard for my project states under 'resources remaining' I have data transfer available of 259gb. So the questions here for me are;...

optimistic-gold

6/19/2024

Is @@fulltext feature can be used?

Hello! This is my schema file: `generator client { provider = "prisma-client-js" previewFeatures = ["fullTextSearch","fullTextIndex"]...

genetic-orange

6/19/2024

Saving files to db

Hi team, I am currently making a resume builder application and was wondering for the templates to my site can I store them on my neon database?

magic-amber

6/18/2024

Deleting Branches

👋 Hey team, how would I go about deleting branches that are all the parent of my primary branch? When I try to delete it, it doesn't work since Neon says the parent branches have children, but I can't delete the main (primary) branch because when that's where the most recent data is. When I try to copy that data into another branch, the main (primary) branch becomes the parent of the new branch, meaning I can't delete the original main branch either. E.g. in the attached screenshot, I want to be able to delete all the parent branches. This will help free up some storage. Please let me know if I can provide any additional information. Thank you!...

Previous Next

Gaming

Programming

Neon

The official Neon Database Discord

Neon

The official Neon Database Discord