Neon

N

Neon

The official Neon Database Discord

Join

šŸ™ļ½œfeedback

ā“ļ½œquestions-and-answers

🐘|postgres

foreign-sapphire
foreign-sapphire8/19/2024

Question about deleting old backup branches

Hey Neon DB team! I noticed in a Discord thread from May that you guys mentioned working on a feature to delete old parent branches from restorations. I'm really curious about this because it's something that affects quite a few of us. Currently, we're stuck with these old branches eating up storage and making things a bit messy. Any updates on when we might see this delete feature roll out? ...
other-emerald
other-emerald8/18/2024

Connection issue on first couple of request

Hello There, I’m currently using the free tier for testing purposes on one of my PoC projects, and I've encountered a significant issue. Whenever there’s no interaction with the database for an extended period, my application experiences a connection issue on the first request. Below are the details of the stack I’m using: 1. Python - 3.12 ...
rival-black
rival-black8/17/2024

Problem using AWS DMS - Unable to Connect During Migration Task

Hello, I'm experiencing an issue while trying to migrate data using AWS DMS as per the "Migrate with AWS Database Migration Service (DMS)" guide: https://neon.tech/docs/import/migrate-aws-dms I've successfully created the source and target endpoints and verified the connections manually using the "Test connection" check manually (which reported success). However, when I attempt to execute a migration task or run the serverless replication using these endpoints, it fails with the following error message:...
foreign-sapphire
foreign-sapphire8/16/2024

SequelizeConnectionRefusedError

Hello, I'm trying to use Neon with Sequelize and keep running into a [SequelizeConnectionRefusedError]. Migration and seeding with Sequelize's CLI both work, but when I try to access the database while the main application is running—e.g. by calling the model's findOne, findAll, create, or bulkCreate method—I hit the error, even though findOne and bulkCreate work during seeding. My Sequelize config.js: ```js require('dotenv').config();...
fascinating-indigo
fascinating-indigo8/16/2024

ERROR: extension "ulid" has no update path from version "0.1.3" to version "0.1.5"

ALTER EXTENSION ulid UPDATE TO '0.1.5'; ERROR: extension "ulid" has no update path from version "0.1.3" to version "0.1.5" (SQLSTATE 22023)...
dependent-tan
dependent-tan8/15/2024

ERROR: Console request failed

Hi, I am currently backing up my neon DB (it's vercel postgres, but as I understand neon under the hood, and even uses a neon endpoint) once every 6 hours. Most of the time it works fine, but in two instances in the past 4 days, there is just an error that says "ERROR: Console request failed". There appears to be no further information about the error. The times that the connections failed was...
No description
other-emerald
other-emerald8/15/2024

Data transfer quota

Hello, neon team! I am on free tier now for postgresql product, and this month suddenly used out transfer data, not sure attack or abuse. So I want to backup db data for now, it keeps raise transfer quota error in console or pg_dump, can anyone help with it?
absent-sapphire
absent-sapphire8/14/2024

restore branch for node.js

I want to use the node.js library to execute a restore branch action (https://api-docs.neon.tech/reference/restoreprojectbranch) the documentation seems to be out of date... Can I get an example of how I can make this request? Specifically, I want to restore a staging branch with the latest data from main....
fair-rose
fair-rose8/14/2024

fuzzystrmatch Extension Not Working

I am attempting to use the fuzzystrmatch extension on Neon. I ran:
CREATE EXTENSION fuzzystrmatch;
CREATE EXTENSION fuzzystrmatch;
and it ran successfully. but when I try to use the levenshtein function or any of the other functions from the extension:...
jolly-crimson
jolly-crimson8/13/2024

Security measures for use with AWS Lambda?

Hi, Can anyone provide any guidance on security with regards to using Neon with AWS Lambda? I feel a little uneasy with having our database reachable via the public Internet. Thanks!...
sensitive-blue
sensitive-blue8/12/2024

I am getting project size limit errors

I got could not extend file because project size limit (600 MB) has been exceeded although in billing I see that I have 10GB. Am I doing something wrong or is this a bug?...
No description
conscious-sapphire
conscious-sapphire8/12/2024

Immutability and tamper-evident?

Hey! Are there any plans to expand the scope of Neon into the immutability/ledger db space? We have solutions such as ImmuDB, Dolt SQL, XTDB, SQL Server 2022 Ledger and so on which provides cryptographically verifiable tamper-proofing of data (i.e., you cannot change data in the database without traces). Does Neon see this as something within its scope?
rising-crimson
rising-crimson8/9/2024

[Solved, request clarification] Adding a unique constraint causes failing query

Hey all, I'm looking to migrate a Laravel application to Neon. While running migrations I run into the following error: ```...
solid-orange
solid-orange8/8/2024

Neon on K8s

Hello I am trying to run neon on k8s using neon/helm-charts repo. I have applied PRs with minio, pageserver and safekeeper. Made pageserver and safekeeper see each other using k8s service DNS. I also build docker image with a compute, made helm chart and deployed it to my cluster. I have encountered two of issues 1. compute says Storage auth token not set. How can I set it?...
No description
ratty-blush
ratty-blush8/7/2024

Deleted my Google account (it is now an alias), can no longer log in

I changed my email and deleted my old Google account. I now have that old account as an alias for my new Google account. I can no longer access my old Neon account because it was tied to my old Google account. Is it possible to change my auth? I can't access my account anymore...
flat-fuchsia
flat-fuchsia8/7/2024

Are we no longer able to create new databases in a project on free plan?

Hey all, I've been using Neon to work on portfolio projects with a production and test database. In the free tier, I was able to create new databases as long as they were part of the single project. But now 'Create new database' doesn't respond when I click it from my Project Dashboard. Has it been disabled?...
other-emerald
other-emerald8/7/2024

Error when trying to add a user.

Trying to add a user from our team to Neon. He showed up under sharing but the project did not appear in his list and he could not access it. I revoked the access and sent him another invite but when he accepted he received the error "cannot authorize request by unknown reason"
probable-pink
probable-pink8/7/2024

Github action failing

Hi all, Since an hour ago, I've been getting an error in my Github Actions workflow. You can see the error in the screenshot. It says it's a SyntaxError. The weird thing is, this action worked perfectly fine just an hour ago, but now when I push changes to existing or new branches, the action fails with the error shown in the screenshot. I hope someone can help me figure out what's going wrong or how I can solve it!...
No description
foreign-sapphire
foreign-sapphire8/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...