storage capacity

[amykirschner]

@ziyan-junaideen got this notice from heroku. I'd like to avoid upgrading to a paid account for about 6 more months. Are there some parts of code we can remove? There is a lot in admin dashboard I don't use if we need a starting point.

The database HEROKU_POSTGRESQL_GRAY_URL on Heroku app mighty-sea-9942 has exceeded its allocated storage capacity. Immediate action is required.

The database contains 10,188 rows, exceeding the Dev plan limit of 10,000. INSERT privileges to the database will be automatically revoked in 7 days. This will cause service failures in most applications dependent on this database.

To avoid a disruption to your service, migrate the database to a Hobby Basic ($9/month) or higher database plan:

[ziyan-junaideen]

Not actually. This is about the database. I thought the database would have been upgraded to a paid plan.

Currently we are using the Hobby Dev Freeplan. That is only advisable for applications in development (ex: staging env of a website). The Hobby Dev Basic plan will increase it to 1 million rows. That is $9/mo.

We can update the database to it. I think I have previleges to do it, so if you are fine with it, I will do it tomorrow morning my time because the app will have to be taken offline for the operation. It can take about 5 / 10 minutes to complete.

[ziyan-junaideen]

I was checking the currently used add-ones. The current billing is at 20$/mo and with a 9$/mo it will be nearly 30$/mo. If we move to a VPS we can keep the cost at 10$/mo.

[amykirschner]

@ziyan-junaideen database got it. Here's the plan, let's upgrade for now to the hobby basic plan. When we get a little bigger, towards the end of next year, maybe we'll do an evaluation and see if moving it to a cheaper place is an option.

If you can do it, go ahead, if I need to login and do something, let me know. Thank you!

[amykirschner]

I'm also taking a backup but if you can do one too I'd appreciate it (in case I'm doing it wrong!)

[ziyan-junaideen]

Sure, the upgrade involves creating a new database and then copying the old data there. Chances of failure is low. But there will be down time because we can't let the old database change during the process. It is rather straight forward and I can handle it in a few minutes.

Going to the account, I was also warned that we are using a legacy stack in Heroku. I will look in to the docs to see how to upgrade (as I remember it is also a quick task) and do it.

With it done, and with the rate the app has grown in the last 5 years, I assume it can live in similar pricing and without need of technical intervention (migrations) for many years to come.

Sure take a backup, i will any ways take a backup before starting.

[ziyan-junaideen]

@amykirschner : It seems I don't have permission to add paid addons. There is a way you can do this in the admin side.

• Login to heroku
• Select app
• Select 'Resources' tab
• Scroll down to addons
• Search for 'Postgres'
• This will open up a modal with plans
• Select the 9$/mo plan

After that I can take on. Sorry for the hassle.

[amykirschner]

working on it. There is no "buy now" button anywhere that I can see. submitted ticket to customer serive

[amykirschner]

@ziyan-junaideen sorry for the delay. It turns out I do not need to approve any plans ahead of time. My credit card is on file, so if you just go ahead and upgrade, they'll start the charges automatically. Thank you!

[ziyan-junaideen]

What I meant is Amy, I don't have permission to add a paid resource. You will have to do it for me. I will there after migrate the data to the new database.

Item could not be created:
You do not have permission to manage paid addon resources on mighty-sea-9942. Only the app owner, <your email>, can do that.

[amykirschner]

hmm. their customer service seemed to imply that you did. I'll go in and check right now.

[amykirschner]

Sorry, I can't figure this out. I've tried configuring the addon as you suggested and also going into my account settings. There seems to be no way to pre-emptively purchase the Hobby Basic level as the owner and I can't figure out how to increase your status to someone who can approve charges. I've pinged customer service again with your error message. Sorry for the delay! I don't know why they are making it so hard for me to give them money!

[amykirschner]

I think I have done it! I installed Postgres copper, old one is postgres gray - see if it works.

[ziyan-junaideen]

Yes it is done.

[ziyan-junaideen]

Do you want me to start the migration now or shall I do it when it is midnight your time / tomorrow morning my time?

[amykirschner]

go for it. :)

[ziyan-junaideen]

Starting now...

[ziyan-junaideen]

@amykirschner : its done. App is live and running.

[amykirschner]

Great! Thank you!!