Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

harsh-harlequin
harsh-harlequin8/7/2024

About pricing

Hi, after i discovered pricing page in here: https://neon.tech/pricing. i got some questions: 1. I know if billing got calculated from compute hours. so, what if we run multiple instance ? does it instance count deployed will be multiplied by its compute hours ? ``` 2 vCPU instances x (2vCPU x 2 hours) = 8 compute hours...
exotic-emerald
exotic-emerald8/6/2024

data transfer

Hey Neon - loving using neon so far - working on a PoC side project. Saw an email that I've gone over the data transfer limit - already for August, which was unexpected, as last month I hit it around 24th July. It is possible to get a daily run down of the egress as I am trying to debug. Note: I only have 1 project...
compatible-crimson
compatible-crimson8/6/2024

DB Locale

Hi, I encountered an issue when restoring database dump into neon, fails with
ERROR: ltree syntax error at character 12
CONTEXT: COPY tablename, line 17, column name: "ü"
ERROR: ltree syntax error at character 12
CONTEXT: COPY tablename, line 17, column name: "ü"
the LC_COLLATE of the DB that created the dump is en_US.UTF8 (default in cloud SQL) ...
constant-blue
constant-blue8/6/2024

Crypto payment

Can someone who works at Neon help me in order to pay my plan using crypto?
exotic-emerald
exotic-emerald8/5/2024

Neon Github action for deleting a branch is flakey

I have the following github action script, and often times the delete-branch step fails ``` name: Neon Testing on: push...
No description
eastern-cyan
eastern-cyan8/4/2024

How cancel my subscription?

Hello, I want to cancel my subscription. I need to contact someone from support please, thank you very much.
eastern-cyan
eastern-cyan8/3/2024

AggregateError [ETIMEDOUT]

when i try to run this code ```ts import postgres from "postgres" import config from "../config" ...
quickest-silver
quickest-silver8/2/2024

Is it possible to allow other users to view database information the from NEON website?

Is it possible to allow other users to view database information the from NEON website? Or is the main way to grant someone access via database permission via a third-party tool? We were also looking to save queries within NEON SQL editor online and share to others....
unwilling-turquoise
unwilling-turquoise8/2/2024

Suddenly not able to connect to pg on free tier

I was able to connect all day today and suddenly am not. I've not changed the connection string or connection code. I'm on rust. I checked how many connections are open and it says 3. Not sure why this is happening.
exotic-emerald
exotic-emerald8/1/2024

Not able to connect from Next.js Vercel appp

HI Everyone we are facing a strange issue with our Next.js app where we when try to connect to NEON from our deployment or do a insert operation it fails with with SS attached Message whereas on local everything works perfectly fine honestly after being baffled for good 6 hours we have lost it any idea how to navigate the same our connection .ts ```import { drizzle } from "drizzle-orm/neon-http";...
No description
conscious-sapphire
conscious-sapphire7/31/2024

Unexpected error happened 😕

im getting this error in my project, it was working well, i just try to filter some tables and this happened, i need answer cause this project is in production, please help me
No description
eager-peach
eager-peach7/31/2024

Tables view crashing after deselecting all columns

Hi, I just installed and imported data into Neon to test if my company should switch to it, and after playing 2 minutes with it I deselected all filters from a table view and the whole Tables view crashed and keeps showing this error now: TypeError: Cannot read properties of undefined (reading 'type') at setFilterView Any idea how to fix it?...
stormy-gold
stormy-gold7/29/2024

Migrate DB from SG to US

I have been working with support for over a month now for migrating my DB from SG to US. I can take a DB dump of the dev and migrate it succesfully but can't do it for the prod branch. Its not that big of a DB either,. Currently it has less than a 1million record and under 6GB. When I started the migration it was under 500K and 2.64GB and now its growing and with its growing size its is becoming more diffcult to have it migrated. Everytime it gets stuck at 1 of the 2 tables one haveing under 290...
broad-brown
broad-brown7/28/2024

Never-ending CONNECTION_CLOSED errors.

So, my node projects makes about one database query call every 10 minutes, and every now and then, I get errors like these: So, the connection to my database is closing, how do I solve that from happening? Or is it possible to programmatically check if my connection is closed, and if so, re-open it, and run the query again? The error in text-form:...
No description
vicious-gold
vicious-gold7/27/2024

Vercel integration not working?

Yesterday, around the middle of the day, all records in our db disappeared. Still have the tables, there's just no records in any of them. Here's a pic of my user table. Any help or info available? Pic is user table in Vercel data browser....
No description
generous-apricot
generous-apricot7/26/2024

Newbie -connection issues

Hello I am getting this error : PostgresError: The requested endpoint could not be found, or you don't have access to it. Please check the provided ID and try again. Does anyone know what I’m doing wrong ? A you help me please ? ...
ratty-blush
ratty-blush7/26/2024

Endpoint to ping

Hi there! A couple days ago we hit the maximum of the free plan Data transfer. We quickly upgraded to the Launch plan, but I’m curious if there’s any way to know if our service is down. We’re currently using uptimerobot.com to monitor our websites and APIs. ...
quickest-silver
quickest-silver7/26/2024

Branch limit and managing branches

Hello! Our team recently hit our branch limit of 500. We noticed this after the Vercel integration stopped providing environment variables, causing our builds to fail. I manually deleted some old (~1 year) branches but I'd like some tips on how to manage branches. Namely, is there a way to automatically delete old branches? I've read the docs page on managing branches (https://neon.tech/docs/manage/branches) but the only insight was manually deleting them one by one. It's a bit tedious to go through 500 branches manually only for the limit to fill up again sometime in the future. Thanks in advance!...
rare-sapphire
rare-sapphire7/25/2024

TypeScript library for neonctl?

Does anyone have advice for how to interact with the Neon "control" API (like neonctl), but from TypeScript? All of my CI scripts are written in TypeScript, and I would like to avoid untyped shell calls & untyped API calls since it's harder to maintain without docs in IDE. So, if I want to have typescript types, should I generate an API client from OpenAPI specs, or is there something existing I can use?...
optimistic-gold
optimistic-gold7/25/2024

Vercel Integration Busted?

Hi, As of today, we started getting the following error on all of our deployments: error: Environment variable not found: DATABASE_URL_UNPOOLED....
No description