Neon

The official Neon Database Discord

Join

Neon

The official Neon Database Discord

Join

🙏｜feedback

❓｜questions-and-answers

🐘｜postgres

sensitive-blue

8/31/2024

Guys can you help meWhy the timezone is different when I create a data. it far behind 8 hours.

Singaopore server

passive-yellow

8/28/2024

Reset branch from parent without resetting password

Hey There, we use one protected master branch and several child development branches, which we regularly reset from the master branch to keep them up to date. However, each time we do a reset, the password changes and we have to update all development environments with the newest credentials. Is there a way to keep the old branch password when resetting?...

sunny-green

8/28/2024

exceeding data transfer limits on free tier

i’m up to 4.85gb / 5gb with only a few days of the month remaining, never got an email about getting this close despite the pricing page suggesting emails get sent when close. rough math suggests i'll exceed the 5gb limit in the next 24 hours happy to pay for extra usage, but i don’t need the full $19 per month launch tier resource allocation, i barely use the free limits other than data transfer. is there a pay as you go option available at all? also was this data transfer limit added recently? it's the first time i've seen it in the billing page, and it's not documented in the plan details, only under docs -> usage metrics, which i only found by looking at the aug 2nd changelog that outlined this change....

other-emerald

8/27/2024

Cannot restore data

Hi, you can see from the screenshot that the current history retention period is set to 1 day, but the error box on the bottom says the timestamp is from the unreachable past. Am I doing something wrong or have I lost data?...

like-gold

8/26/2024

I have a new NeonDbError "password authentication failed for user 'xxxx'" error when using Pool

Previously, my code seemed to be working fine until I switched to creating the database client as a Pool. The neon connection string is created in CI and passed into the server environment automatically, and this is the first time I'm seeing this error. Is it known to be flakey/slow at creating connection strings that immediately start working? Or is there a difference between http vs websocket vs pool clients in Drizzle? I can provide more details on the setup and everything, but I wanted to ask here first...

afraid-scarlet

8/26/2024

Can't reach database server at `ep-icy-dust-a4s6p4wh.us-east-1.aws.neon.tech:5432

getting this error when using prisma genereate client command ``` npx prisma migrate dev --name init Environment variables loaded from .env Prisma schema loaded from prisma/schema.prisma...

rare-sapphire

8/25/2024

Drizzle ORM + Hyperdrive

Hello all 🫡 May I please ask you which postgresql driver you consider the most optimal one, when being used by drizzle orm and hyperdrive for cloudflare workers? I understand that drizzle orm supports the neondb serverless as well:...

eastern-cyan

8/25/2024

does neon support pgvectorscale

Title

correct-apricot

8/25/2024

Branch Parenting Issue

A few months ago I restored a backed-up branch for a borked migration from a different server. I now have created my "main" branch from this backed-up branch and is currently using it on production. As of now, my branch naming's are kind of messed up and I want to clean it up. My issue here is that, my "main" branch parent is from "main_backup", and that one has a parent of "main_old_2024-xxxx". I am unable to delete this "main_old_2024-xxxx" branch due to this parenting issue. Is there a way to reset this hierarchy and have all of the branches deleted without touching the "main" branch?...

genetic-orange

8/24/2024

Hosting services for the .Net Core Web Application

I want to use Neon Serverless Postgres in a .Net Core Application in the US East (N. Virginia) region. Which hosting services for the .Net Core Web application do you recommend considering low latency between the database and the application and also cost-effectiveness?...

optimistic-gold

8/23/2024

Migration Workflows

We are using Vercel, Neon, Prisma and GitHub. I've set up the Neon Vercel integration, as well as the Github Vercel integration, and everything's working well. Our workflow right now is: 1. Create a branch off of main. This causes Vercel and Neon to spin up a branch specific environment....

eager-peach

8/23/2024

Sqids Extension Support

Is there any plan to support the official https://github.com/sqids/sqids-postgresql extension? Currently neon supports https://github.com/iCyberon/pg_hashids. However, i believe the algorithm and conseqently ID generation has been updated.

harsh-harlequin

8/22/2024

Is there a way of visualizing the schema of my DB in Neon?

I am looking for an easy way of visualizing my DB schema. I've looked for a built in tool but found nothing. Is there a way you guys can think of for visualizing the DB schema? Something like this is what I'm looking for!...

conscious-sapphire

8/22/2024

You've reached 100% of your monthly storage limit.

Good day everyone. I have reached 100% of my monthly storage limit. I was busy migrating my database from MongoDB to Neon and was running several Python scripts on the data to make sure that all the data gets to its new home in the desired format; thus I was running the psql command in my terminal often to copy the data over to Neon once a new variation of my Python script was done executing... When it seemed like I finally worked out all the kinks in my Python script I got "ERROR: could not extend file because project size limit (512 MB) has been exceeded" and was not able to successfully import any of my data from the CSV. The Neon database as is has hardly anything on it and the history setting is set to only retain the history for 1 hour....

absent-sapphire

8/22/2024

93% monthly storage limit while only storing ~30 MiB

I am seeing a banner that I am reaching my monthly storage limit of 512 MiB while I am only storing 29.98 MiB. I have a single branch and have only been using this connection for a little over a week now. Any idea what could be causing this?

absent-sapphire

8/20/2024

Delete restore parent branch

Hi, after I restore my main branch from another point-in-time, I would like to delete the backup branch generated by the restore proccess but I cannot doing until all children branches are deleted. The problem is that I don't want to delete the main brach (child branch from the restore). Is is possible to "detach" the main branch from its parent branch?

other-emerald

8/20/2024

--cu command not being respected when using `projects create`

neonctl projects create --name "${projectName}" --region-id aws-us-east-1 --cu 0.5 --output json This results in a branch being created with 1 CPU still...

genetic-orange

8/20/2024

Cannot view tables of database

Hello, I have a db I've created on the free plan with a table I created using a migration script. My application is able to write and read from the correct table however when I try to view or query the tables in the Neon dashboard or using psql, I am unable to see the tables in my db. \dt gives "Did not find any relations"

correct-apricot

8/20/2024

Cannot create branch in a new personal project

Hi, I am unable to create a branch from the main branch. When I try to create one, it gives me this error: Request failed: compute time quota of non-primary branches is exceeded I've attached a screenshot as well. I'm not sure what this means. It is a super fresh project. I just created it, so I don't have any other branches in this project, only the main branch....

wise-white

8/19/2024

How to see branch restore history?

I'd like to see a history of when my "main" branch was restored, and from what sources it ws restored from. Where can I view this history?

Previous Next

Gaming

Programming

Neon

The official Neon Database Discord

Neon

The official Neon Database Discord