Neon

N

Neon

The official Neon Database Discord

Join

🙏|feedback

❓|questions-and-answers

🐘|postgres

firm-tan
firm-tan2/23/2024

"non-primary branch calculation time is exceeded" despite 0 hour compute time

For my Neon project, I have a primary production branch, a non-primary test branch, no other branches, and I'm on the free plan. Looking at my Branches in the Neon console, it looks like my hours were just reset today or yesterday - my production branch has 0.47h active time, and test branch has 0h active time. However, when I try to connect to my test branch (easiest way is to click on Tables when viewing the branch in the Neon console), I get the error Request failed: non-primary branch calculation time is exceeded. From my understanding of the new free-tier allowances, my primary branch should be always-available, and my test branch should get 20 hours per month. Is that correct? If so, this seems like a bug....
other-emerald
other-emerald2/23/2024

prepared statement \"s0\" does not exist vercel integration, missing pgbouncer=true in DATABASE_URL

The integration does not add pgbouncer=true to the url, making pooled urls break it seems?
solid-orange
solid-orange2/23/2024

Vercel build: Neon branching · Status not available

Hey, I'm trying to set up the Vercel + Neon integration. I followed this tutorial: https://neon.tech/blog/branching-with-preview-environments. I already have the integration setup on Vercel and the branch creation is working. Still, the GitHub Action always fails when deploying the project artifacts to Vercel on the running checks with Neon branching · Status not available. This is the PR where I'm working on https://github.com/betoSolares/startpage/pull/18...
No description
adverse-sapphire
adverse-sapphire2/22/2024

Error connecting neon.tech db to the node.js application

When I try to connect to the database on the neon tech , I am always getting an error stating that AggregateError ETIMEDOUT ENETUNREACH Code and Error is mentioned...
No description
solid-orange
solid-orange2/22/2024

Neon Serverless + Prisma + Vercel Functions

Hello, I want to leverage the Neon Serverless client + Prismaon an app deployed to Vercel Functions . Neon Docs specifies the following Client instantiation: ``` import { Pool, neonConfig } from '@neondatabase/serverless'...
other-emerald
other-emerald2/22/2024

Vercel Neon integration missing non-pool url

The integration only sets pooled URL on the DATABASE_URL and are not adding a second one for non-pool. Making prisma migrations hard to do. This is incredibly annoying on preview builds, as it needs to be added manually to deploy. Does anyone know how to fix this? Or should Neon fix this in their integration?
equal-aqua
equal-aqua2/21/2024

Connecting to Google Looker Studio

I'm trying to connect Looker Studio to my Neon database but am getting a vague error from the UI:
Sorry, we encountered an error and were unable to complete your request.
Sorry, we encountered an error and were unable to complete your request.
...
correct-apricot
correct-apricot2/21/2024

Error: endpoint is temporary unavailable. check your quotas and/or contact our supp

Hello. I'm facing this error while fetching data from my database:
Console request failed: endpoint is temporary unavailable. check your quotas and/or contact our support
Console request failed: endpoint is temporary unavailable. check your quotas and/or contact our support
What does the error mean and how can I resolve it?...
foreign-sapphire
foreign-sapphire2/21/2024

suspend_compute error on neon free plan

I tried to connect to my branch but it always timeout, when i checked the dashboard the action
suspend_compute
suspend_compute
is having an error but i dont know what the error is. tried to restart the endpoint using my API Key & CURL https://api-docs.neon.tech/reference/startprojectendpoint still no luck which give me this error ``` { "code": "",...
No description
harsh-harlequin
harsh-harlequin2/21/2024

pricing question

Hey guys, how does the new pricing work with scale to 0? I'm on launch plan but won't use 10GB/300h/10 projects this month and I can see my current usage bill is $2. Will I pay $19 at the end of the month or $2? In other words; Is the $19 estimate for 10GB/300h/10 projects usage or monthly subscription payment?...
genetic-orange
genetic-orange2/21/2024

NeonDB is Down? Experiencing compute issue

As the title says, NeonDB seems to be down for me, is anyone experiencing the same? It is stuck on "IN PROGRESS" for a long long time. We have a very crucial website running on this and this downtime will cost us a lot. FYI my DB is on Asia Pacific (Singapore) region...
No description
curious-teal
curious-teal2/21/2024

Starting compute take a while

Hello, recently i face this issue where sometimes it takes more than 10 minutes to start a rw compute process. i'm using the free tier and Asia Pacific (Singapore) region...
No description
foreign-sapphire
foreign-sapphire2/20/2024

Passing outputs into another job (create-branch-action)

I am using the neondatabase/create-branch-action@v4 github action for ci/cd pipeline. I have configured the ci/cd into 2 jobs where 1 job is responsible for creating a neon branch, I am not able to utilize it to build my app. Reason being they are masked https://github.com/neondatabase/create-branch-action/blob/main/action.yml ...
No description
flat-fuchsia
flat-fuchsia2/20/2024

Free tier Project Sharing

Hi!, have been enjoying using Neon for the past few weeks, was excited to hear with the new pricing that "project sharing" would now be included with the "free tier", At the moment when following the documentation (https://neon.tech/docs/guides/project-sharing-guide) I don't personally see the "Sharing" option for my project Could this be because my account was created before the new pricing tier and so my account might not have the latest permissions/features that new accounts would receive?...
No description
other-emerald
other-emerald2/18/2024

Change a value direct in my db with Neon

Hi! I am looking for how to change a value directly in my Neon db. I have few users with status and I woulde like to attached to my User Account the value "Admin", because only "ADMIN" can do specific things on y website. ...
wise-white
wise-white2/16/2024

Image similarity search using NeonDB

Hi, I found out about PGvector with Neon DB and noticed there's no image search template yet. I've built something similar using Vertex AI and FAISS over at this repo https://github.com/ItzCrazyKns/Image-Search. I'm wondering if I could help out with building one for Neon DB. Let me know if that sounds good
manual-pink
manual-pink2/14/2024

NeonDbError: data type json has no default operator class for access method "btree"

Hi all, I am using Drizzle ORM to create a Postgres schema like so: ``` export const Locations = vendorPortalSchema.table("locations", {...
xenial-black
xenial-black2/13/2024

Creating a TimescaleDB Hypertable

Hi y'all, I'm creating a prisma migration for an existing table on Neon ``` -- This is an empty migration. -- Enable TimescaleDB...
No description
environmental-rose
environmental-rose2/13/2024

Issue with roles

When I started our database it added my full name as the owner role, and a while back we switched it to another role so a bunch of tables were created with both role. the issue is that our prisma migrations are failing on it, I believe this is because the role needs to match the one that made the table? ...
vicious-gold
vicious-gold2/13/2024

Restoring a branch to point in time prior to a reset

I have a parent branch "main", and a child "dev". I entered data into "dev", then reset it to the parent. I am trying to restore it to before the reset and getting an error "Timestamp belongs to the past, where historical data is not available". Is this a possible operation?