Our primary branch "main" now has parent "main_old"
As background we are new to Neon. We have several projects (development, staging, production) and in each project we have several branches. We just noticed that for development project the "main" branch which is marked "primary" now has a parent branch named "main_old_2024-04-29T21:29:39.677Z". I am trying to understand what created this "main_old" branch and if it is a side-effect of the way we are using Neon.
Notes:
1. We currently have 23 branches
2. We create a branch for each PR that is opened and then remove the branch when the PR is closed....
Staging and Production (Blue/Green) Deployments on Neon?
Hi, we have a live web application that uses a Postgres database on the neon
main branch. A data pipeline that loads this database with fresh data takes a while to run (20-30 minutes), and the updates involve refreshing data, which essentially causes application downtime.
Is there a way to have a staging branch to update the database, and to propagate the changes to main , which the application sees after the update has completed, so that the database that the app utilizes is never down or refreshed through the pipeline directly, and instead copies over changes from staging?
Cheers....Incorrect db_url after using github action create-branch-action
I'm leveraging the neondatabase/create-branch-action@v4 github action (https://github.com/neondatabase/create-branch-action).
After creating the branch, I try to get the database URL with the command
echo "NEON_DATABASE_URL=${{ steps.create-feature-branch.outputs.db_url }}" >> $GITHUB_ENV;...Glitching webpage whilst using SQL editor
after entering and running few lines of sql, the webpage suddenly began glitching (flickering from console.neon.tech to console.neon.tech/app/projects) . ive closed the webpage, web browser, hard reloaded, closed via the task manager, cleared cache, turned off extensions and restarted my pc and it still hasn't changed anything, the page still glitches. i can however log in perfectly fine on my phone
Migrating from Supabase
Hey guys!
Love Neon. I am just trying to migrate from Supabase to Neon, as I have an issue with max connections in serverless and high-scale environments which Neon is perfect for.
I am trying to migrate my database, however my database in Supabase is called postgres, which is protected in Neon. Any possible solutions?
...
Neon Console SQL Editor: ERROR: cannot execute XYZ in a read-only transaction
I haven't touched my Neon project for a few weeks and apparently there's a new bug now in Neon Console's SQL Editor: I'm unable to execute any query that requires write access. I have two compute instances assigned to my
main branch, one RW compute that auto-suspends, and one RO compute that's always on. Although I selected the RW compute in the SQL Editor, I always get an error when I try to execute a write query.
E.g. when I try to comment on my DB:
```sql...Is there a way I can setup neon branch like setup with local DB
Every developer in our team has a dedicated branch to use for local development. However, I live quite far away from where the database is hosted, which makes local development pretty slow.
Is there anything I could do to overcome not using neon branches?
With the neon branch I only need a single neon branch, I can reset it easily whenever I want to switch git branches (eg when this is needed: migration is applied in the old branch, whose migration file would be missing in the new branch )
When using the local database, I would have to reset the database to apply migrations and sync....
what's suspend database feature used for?
hello, I'm on launch plan, and there is setting to suspend database, and its till active (checked by default) even I upgrade to launch plan
but what exactly this used for?
isn't it better to not have cold star?...
SOC2 Controls using Neon
We have recently migrated from using Google Cloud SQL to Neon. We love the solution and are pleased that we made the migration. We are now starting to prepare for our annual SOC2 audit and the solution for Neon doesn't align with the typical narrative for SOC2. I was wondering if you have any recommendations on how to present the Neon solution so it aligns with the expectations of a SOC2 auditor?
We are planning to communicate that we use the time travel feature if data becomes corrupted. Additionally, we are concerned the auditor will be bothered by our Neon data residing in a single region. One solution that would really help is the ability to configure a read replica in another region that could be used for a hot backup. If we had the read replica and time travel then I think we could work with the auditor to explain how we have a robust solution that can handle disasters. Any thoughts are greatly appreciated!
Example Controls:...
Can't use Prism
After pasting the schema.prism and .env sections I tried to run this command
npx prisma migrate dev --name init
However, I get this error:
Environment variables loaded from .env
Prisma schema loaded from prisma\schema.prisma...
`@neondatabase/serverless` connection string doesn't accept strings without passwords?
Couldn't find much info on this online, but I'm runnign into an odd error with
@neondatabase/serverless and trying to initiate a neon instance.
Using the snippet from the drizzle docs:
```ts
import { drizzle } from "drizzle-orm/neon-http";...Change culture in database
hello. Can you tell me how to change the database culture? I want to do this because the lower function in my database does not work with Russian letters right now. And it says in stackoverflow that to do this, you need to change the culture in the database
NextJS and Prisma: Can't reach database server at `ep-dark-dust-a2bf50ze-pooler....
I am getting the error:
Can't reach database server at
ep-dark-dust-a2bf50ze-pooler.eu-central-1.aws.neon.tech:5432
Please make sure your database server is running at ep-dark-dust-a2bf50ze-pooler.eu-central-1.aws.neon.tech:5432....Can I use AWS credits to pay for launch/scale plans via AWS marketplace?
Recently neon in its pricing made possible to pay through AWS marketplace the launch and scale plans. Startups usually receive free credits (between $1000 and $5000 USD) with their AWS account. I was wondering if I can use this credits to pay for these plans.
Unable to change owner of table
Hello! I have a Prisma ORM issue where I need to ignore certain tables from my introspection and migrations. There is currently a feature request for this as it is not directly available, however, the current workaround is to have 2 roles, and only grant ownership of the tables Prisma should manage to the prisma user.
I have created the prisma user, however, all our tables were created using the older user. I try to run
ALTER TABLE "Account" OWNER TO prisma; but I get an error that says must be able to SET ROLE "prisma". I don't see anything in the documentation on this so is it not possible to accomplish what I am trying to do here, short of blowing away all our data by dropping the tables and recreating them with the proper user?...I can't alter any table from Neon SQL Editor because I can't select the owner of this table
Hey Guys,
I have had a problem that has persisted for months now: when I create multiple roles using Neon UI, connect to the database using a specific role, and create a schema and tables using that role, I cannot modify that table with another user, and I can not create any table inside this schema.
When I try to change the owner of that schema, I will not be able to do that.
So, I need to be logged in with all the users who created schemas or tables to change multiple tables with various roles, which is painful. I also need to be able to change the owner of a schema and all its tables....
Nextjs Turbopack: NeonDbError: Error connecting to database: fetch failed
getting this error sporadically on my local, it'll spam a handful of them at a time.
```
NeonDbError: Error connecting to database: fetch failed
at execute (/home/***/.next/server/chunks/ssr/3d06b_@neondatabase_serverless_index_mjsad6191..js:4910:21)...
Webhooks
Hey there,
I'm currently developing an application and I'm using Neon for authentication storage and MongoDB for data storage. I'm facing a challenge where I need to retrieve the user ID from Neon.tech and connect it with MongoDB seamlessly.
After some research, I believe the best solution for this integration is through webhooks. However, I'm seeking guidance on how to effectively implement this....
Connection to AWS QuickSight
Hi all,
I'm trying to connect to AWS Quicksight but I get the following error:
The authentication type 10 is not supported. Check that you have configured the pg_hba.conf file to include the client's IP address or subnet, and that it is using an authentication scheme supported by the driver.
AWS community suggest it should be something with the Postgres 14+ authentication and AWS Quicksight:...