Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

rival-black
rival-black4/8/2024

Free Tier Storage

Hi guys, a little help in the free tier, I started my project without knowing the history feature that is called " point-in-time restore" so I worked on my project and was surprised that after 3 hours of work with one database with 2 tables with 3 to 5 rows in each table the storage reached 350MiB from 512MiB then I found the history within 24 hours. so I turned it off and waited 24 hours for the storage reset but this didn't happen and it is still 350MiB. Did anyone know why?...
stormy-gold
stormy-gold4/6/2024

Can't connect from Vercel's Edge

When connecting to Neon locally everything works but once deployed to Vercela Edge I keep getting errors. Note I'm using SvelteKit. When attempting to connect via Pooling I get: INTERNAL_EDGE_FUNCTION_INVOCATION_FAILED on about every other load because of "Error: Your function was stopped as it did not return an initial response within 25s". ```...
passive-yellow
passive-yellow4/5/2024

massive Storage usage

Hello! I currently try to migrate my production data to neon db. Therefor i Upgraded to launch-plan as this is more than enough for my app.. The raw data as csv is less than 1 GB, but when i Imported data via dbeaver it Shows me 77GB of usage and i now have to pay a lot of extra fee... how could that Happen? Is it a Bug? Kind regards...
quickest-silver
quickest-silver4/5/2024

neon branching status not available

Hello there i have some problems when i do a pr , looks like i got a fail check on vercel looks like i get no further info on what this could be , it was working before but all of the sudden creating a branch stop working. What i can think of is that i've been working on this branch for almost 2 weeks , (so i've been doing a lot of pushes on this branch, probably is my biggest branch yet , and we need to test it with my boss on a live site so we really need to deploy it on vercel) Sorry if my...
No description
genetic-orange
genetic-orange4/4/2024

General information about the free plan

good evening, I am ptoving to develop a java app that connects to a postgres db via jdbc using the string generated by neon. I am not very clear about the limitations on the free plan for example : 1.) how many hosts can be connected at the same time? 2.)for how long at most?...
foreign-sapphire
foreign-sapphire4/4/2024

No access to the site and database.

Good afternoon! Please tell me why your site is unavailable and why the connection to the database is also unavailable? Until recently everything was fine.
rotten-yellow
rotten-yellow4/4/2024

Doco for /sql API endpoint

Hi. I was wondering if there was any doco available yet for the query API endpoint (I believe it's available at /sql)? Thanks...
foreign-sapphire
foreign-sapphire4/3/2024

Discord Bot

Hey, I just have a few questions about Neon as I'm moving from ElephantSQL which is closing down soon. I paid like £10 on their site and it was perfect for the time I used it. Is Neon a good choice for hosting a database with that would need to be accessed 24/7 as the Discord Bot is online 24/7 every day of the month, along with our dashboard that would be connected to the database. There is a lot of data that would be added, read and modified in the database. I understand there is compute with Neon, something ElephantSQL didn't have. How does this work? Which plan would I have to get to meet the needs above. We have around 237 MiB of data. I just don't fully understand the whole compute thing at the moment. Thanks!...
ratty-blush
ratty-blush4/3/2024

Unable to transfer data to new DB

Hi all, I'm in the process of handing over a project to a client, part of which is the transfer of ownership of all infrastructure, SaaS etc accounts. Neon doesn't yet have the ability to transfer a DB or project between accounts (from what I can find), so I'm following this guide: https://neon.tech/docs/import/import-from-neon#important-considerations The problem is connecting to the server times out every time. I thought it might have been a postgres version mismatch but I made sure everything is on the same version (15)...
No description
variable-lime
variable-lime4/3/2024

Duplicated operation errors persist

Hey all, We're still seeing this when firing up our app on dev: ``` "Connection failed: {"errors":[{"errorType":"DuplicatedOperationError","message":"Duplicated operation with id 208aefd7-0597-48db-90a0-0bd4b5c8b0ae"}]}"...
wise-white
wise-white4/3/2024

Migrating from Vercel Postgres to neon

I am currently using the Vercel Postgres integration and I wasn't fully aware of the technical limitations it has. I'm interested in moving to neon to have the full access to the console. Any suggestions on how best to do that?
afraid-scarlet
afraid-scarlet4/3/2024

Running Rust executables manually

Hello, is there documentation anywhere on how to run the Rust executables (i.e. in /neon/target/release/[executable name] where "executable name" could be storage broker, safekeeper, pageserver, compute_ctl)? I wanted to do some testing to see if Neon is right for my team's needs. I can't seem to pass the correct params to get each node talking to each other. For example, "./storage_broker" runs fine but "./pageserver --id=1 --broker_endpoint=[local broker IP]:50051' throws a TCP error. I know I'm not passing the correct params (or I'm missing params), but I'm not sure which params and which values I need. I've looked in the Neon repo and I can't find any guidance, does anyone have tips? Thank you in advance! 🙂...
grumpy-cyan
grumpy-cyan4/2/2024

Neon CLI auth

When I run neon projects list, I do not get any projects, but in the web console I am part of one project. I have tried authenticating through the web flow and with an API token. Is there something else I need to do to to be able to configure the neon CLI?
wise-white
wise-white4/2/2024

Does Neon have rate limiting for application logic?

In an effort to mitigate a billing attack, I’m using the @upstash/ratelimit library for a form in my Next.js app. The form is calling Neon anyways, so does Neon have anything similar, in terms of rate limiting at the application level, that I could use instead of Upstash’s rate limiting library?
foreign-sapphire
foreign-sapphire4/1/2024

Increased duration in queries using Pool on Lambda

I have being playing more with Neon Pool driver and found that on Vercel Serverless Function (Lambda), the queries take significantly longer. I'm using drizzle for this test and wrote 2 instances to test with. 1) Edge compatible Pool Driver ```typescript...
automatic-azure
automatic-azure4/1/2024

How to failover in Neon?

I created a database in Neon. The main branch has one RW compute node and one RO compute node. I wonder if there is anyway that I can switch those nodes so that I could monitor a failover process.
rival-black
rival-black3/31/2024

Recommended Workflow w/ Neon and Drizzle

Hi, I am migrating from PS to Neon. Made it past the MYSQL -> Postgres part and now my data is in Neon under 2 branches -- dev and main. My typical workflow with PS was to develop on the dev branch and run npm run db:push whenever I made schema changes. When deploying to prod, a new deploy request would be created and merged for the main branch....
ambitious-aqua
ambitious-aqua3/30/2024

How many Connections can I make with your database?

I'm making a discord bot. I want to connect to same database using Python asyncpg 2 times
rare-sapphire
rare-sapphire3/29/2024

unable to delete backed-up branches after multiple restore.

I executed "restore from history" to the root branch, it created a backup copy branch as a parent. Then I executed it again, now I am unable to delete any of them. When I try deleting the root branch results in an error "cannot delete the root branch" and if I try deleting the other results in an error "cannot delete branch that has children". Does this mean they will stay forever?
No description
foreign-sapphire
foreign-sapphire3/29/2024

Download of backup copy

Good afternoon, community. Can you please tell me if I can download a backup copy of the database? Tell me how to do this.