Cannot drop subscription
I created a subscription to a publication I have on another database, but I forgot to pass the option to copy the data. I figured it would be easy enough to drop the subscription and recreate it with that option, but I cannot get neon to drop the subscription no matter what I try. I've been led to disable the subscription and set the slot to ...
none and I see the subscription when I select, but I can't drop it for some reason. This is the error I get when trying to drop the subscription with DROP SUBSCRIPTION sub_name;
ERROR: could not drop replication slot "pg_147456_sync_107276_7448440708624468072" on publisher: ERROR: syntax error at or near "DROP_REPLICATION_SLOT" LINE 1: DROP_REPLICATION_SLOT pg_147456_sync_107276_7448440708624468... ^ (SQLSTATE 08006)
ERROR: could not drop replication slot "pg_147456_sync_107276_7448440708624468072" on publisher: ERROR: syntax error at or near "DROP_REPLICATION_SLOT" LINE 1: DROP_REPLICATION_SLOT pg_147456_sync_107276_7448440708624468... ^ (SQLSTATE 08006)
Unsure about when my free tier database will become un-paused & a few questions/statements
- I'm not sure when my database will be unpaused. I don't know if it resets every calendar month or just every 30 days from when I created my database/account.
- The website really needs to be fixed for mobile users. It's very hard to navigate (this was on mobile firefox browser app IOS)
- My website is a serverless flask website and a maps website so this means a lot of requests and new connections made basically for each request to my website. Due to this compute time seems to get swallowed up (possibly more than it should due to the neon and my code i guess.)
- In my opinion this is very expensive for what it is. The free tier is the best out there but to upgrade is kind of ridiculous to me. $19/month could get me my own VPS that I could host more than just a database (not just that but no limits besides hardware) the pricing makes it hard to want to stay with neon. I would love to upgrade if it was cheaper and more fair.
- It would be nice if we were able to download our database (even after allowance is gone)...
application balance
I need helpmfiguring out application balance and how yo move it to a bank account
my database is suspended
I reached my compute limit for the month and now my database is suspended. I need the data immediately. What can I do? Is there any option to open the database temporarily just for getting a backup?
pg_restore & Size Limits
Hi, I'm on the launch plan, and I'm hoping to migrate a database that's around 15gb total. I assumed I would get the 10gb on the launch plan, and then just pay extra for whatever goes beyond that. But when I ran pg_restore I got this error:
pg_restore: error: COPY failed for table "my_table": ERROR: could not extend file because project size limit (3072 MB) has been exceeded
HINT: This limit is defined externally by the project size limit, and internally by neon.max_cluster_size GUC...For NeonDB, do you know if i could setup a birectional bi-region databases
For NeonDB, do you know if i could setup a birectional bi-region databases? I know that we can do logical replication from one NeonDB project to another (https://neon.com/docs/guides/logical-replication-neon-to-neon). However, this is a uni-direction from publisher (project A) to subscriber (project B). I tried to setup the reserve direction using the same method but the data does not seems to be replicate back from project B to A
Not sure why I'm being charged compute credits
I received this message from Neon: "Branch compute hours limit approaching. Your personal account has used 80% (4 hours) of the free plan's 5 non-default branch compute hours limit. You'll find a detailed usage breakdown in the Neon console. The total number of compute hours used by non-default branches: 4 / 5 h"
I am surprised by this number. My project has been active for just a few days. I have only deployed <5 changes to my database schema, and I have just 1 user, used for de minimus testing.
Can you explain what the root cause of the branch compute is? I'm afraid that there is an error or bug that is causing branch compute consumption unintentionally.
Thank you very much.
-Ryan...
Freezing/Crashing when creating a new project
Tried neon and tried to create a project but it freezes and crashes the browser. Tried doing it on MS edge and chrome, both froze.
Getting Connection closed. randomly
We have been using Vercel/Next.js/Prisma for a bit and in one specific spot we have
prisma.salesOrder.findMany() including a bunch of other tables (not ideal I know).
When we use order by in this operation, we get "Connection closed.". Things I have done so far:
- Changing the connection string from connect_timeout=15&connection_limit=20&pool_timeout=60 to connect_timeout=60&connection_limit=30&pool_timeout=0...How to have both RLS via JWT and interactive transactions?
I'm working on a codebase where the db connection is using @neon/serverless and Pool, which makes interactive transactions with rollbacks possible. Recently we've started looking into having RLS as well. Following the guide for Neon Authorize, it seems we need to use @neon/http as a driver and pass the JWT token as an
authToken while initializing the database. But then we'll get No transactions support in neon-http driver.
So I am just a little confused on whether we can have both RLS and interactive transactions. One thing I've tried is just passing the JWT token as a local session variable inside each transactions, which allowed the RLS policies to work while keeping our existing interactive transaction. But I am wondering if there's a better way to do it than that
TIA...Question about data recovery
Hi there,
I recently lost some very important files on my Free Plan account due to an accidental deletion that occurred over 24 hours ago.
I know the free plan only keeps 24 hours of history. If I upgrade to a paid plan now, would I be able to go back further in time and recover my old files?...
Control plane request failed
Hello, I am noticing that our nightly import of orders from other platforms keeps on failing with "Control plane request failed". We have
node-cron running at UTC 00:00
```
{
"code":"XX000",...
quota
My free-plan project was automatically suspended for exceeding the 5 GB egress limit. Could you temporarily re-enable the compute for ~30 minutes? I just need enough time to run a compressed backup (pg_dump -Fc -Z9),
Thanks a lot for your help!...
When is Supabase Auth-like SMS/email OTP delivery coming to Neon Auth?
Hi Team, wondering if there are any plans to add OTP delivery to the in-beta Neon Auth? I'll be considering migrating to Supabase Auth, if not- hence the question.
Need help in connecting and referencing table in `neon_auth` schema
Recently started using stack auth with neon. The data for users is coming in
users_sync under neon_auth schema. I am having a problem while connecting to this schema. My Drizzle config defaults to public schema and creates a new table named users_sync.
Here is my table structure in Drizzle,
```
import {
pgTable,...I am trying to reach the sales team for a couple days but there is no response
I am trying to reach the sales team for a couple days but there is no response. I raised a ticket through the website 5 days back and there is no response yet. I scheduled a meeting today and i joined and was waiting for more than an hour and the host hasn't joined yet
Neon branches for custom vercel environments
Hi All, there was a similar question asked about a year ago here (https://discord.com/channels/1176467419317940276/1249785408959807529), but I didn't see a clear answer to the question. Basically we have nearly the same workflow as the OP of the post linked above. We use preview deployments for PRs, but our default/trunk branch is called 'staging' and we merge our PRs into that, which triggers a deploy to our custom vercel staging environment. Then when we want to deploy to production, we creat...
Payment Support team not responding for days
The autopay failed so i tried contacting support for invoice, they haven't responded for over 7 days.
Vercel < > Neon Integration for Branching on Preview Deploys not working (possible bug)
I've been following the official Neon docs to setup the Vercel <> Neon integration, but I'm in a weird state where I am successfully using Neon as my DB in my NextJS app, but I can't setup the preview deploys to automatically create a new db branch.
In the integration section on Neon, I see "Manage Neon Subscription" under the vercel integration (see screenshot)
But clicking it takes me to Neon settings, which don't have the same options that @mahmoud 's videos show for setting up the integration. It's just taking me to the billing page. Any ideas where to go from here?...
