I think supabase db dump is locking up my DB
So I tried to do a db dump of my prod DB to my local machine. However, it was taking over 30 minutes so I
ctrl + c which I thought would kill it. However, my website is now timing out on pages that utilized my DB... Could the db dump lock up my free tier DB?
I did also make some schema changes but I haven't ran drizzle-kit migrate or drizzle-kit push against production yet for those.
The timing lines up with me trying to do a DB dump... It just seems to be sticking around and every log under pooler says Connection failed4 Replies
Yes the database can lock up when doing a
db dump depending on the size of the database and the amount of resources you have freed to perform the db dump.😬 so I
ctrl + c out of it but seems like it's still doing something?
I am somehow getting like 2.3k logs in Pooler very frequently, I am guessing due to this?That won't stop the database from locking up
So how do you stop it after you’ve started it?