How to Upgrade or Downgrade Heroku Postgres adon plan

-
If you are using Heroku and Postgres adon in your project, by the time you may want to upgrade or downgrade Heroku Postgres adon plan based upon your project's database size decrease or increase with time.
Although you can follow Heroku documentation for the purpose:
Changing the Plan or Infrastructure of a Heroku Postgres Database

But I wish to introduce you to another way to upgrade or downgrade the Heroku PostgreSQL Database adon plan.

In this process we have 3 steps to follow:
1. Add additional Heroku Postgres adon with the desired plan (you want to switch) using the below command:

    heroku addons:create heroku-postgresql:adon-plan --app your-appname

Where `adon-plan` can be replaced with the desired plan from the plan list and `your-appname` with your application name.

2. Now copy your database from the old Postgres adon to the newly added Postgres adon.
    
    heroku pg:copy HEROKU_POSTGRESQL_MAUVE_URL HEROKU_POSTGRESQL_PINK_URL -a your-appname

Here `HEROKU_POSTGRESQL_MAUVE_URL` and `HEROKU_POSTGRESQL_PINK_URL` are system URL names of source and destination databases respectively.
If you want to know where you should find these database URL names? you can open the resources tab in your app. Here when you click on `Attached as DATABASE` (or attachments) dropdown. Here you will see the system name of your database and add the suffix `URL` to it.


Here for first for the top database name is `DATABASE_URL` and for the bottom one, it is `HEROKU_POSTGRESQL_PINK_URL`.

3. After your database is completely copied to the new Postgres adon, you can change the default database i.e. promote the new Postgres adon database as the default database using the command:

    heroku pg:promote HEROKU_POSTGRESQL_PINK_URL -a your-appname

Now you are using your desired Heroku adon plan for your database project. You can now delete old Postgres adon to avoid additional billing charges.

So using the above 3 steps you can upgrade or downgrade the Heroku Postgres adon pricing plan.
Location: Chandigarh, India
A man with small desires, likes things in simple conditions, loves god creation, feels pleasure to help someone needy.
Professional: Software Developer (PHP) (5+ yrs) with good hands in latest technologies and Frameworks like Laravel Cakephp 3, CodeIgniter, Wordpress, Core PHP, MySQL, PgSql, jQuery.

Comments

Post a Comment

Popular posts from this blog

Using Virtual Columns in Laravel - Accessors and Appends

-
What are virtual columns?  While developing any web application sometimes we need virtual columns - columns don't actually exist in our DB table, but we drive them from other columns. Why we need them? For example, generally, we use first_name and last_name  in the  users table. But sometimes we also need user's complete name i.e. full_name . There is no benefit of saving full_name in user table if we have already first_name and last_name in the table OR even if we have full_name  as a column in our table then there is no benefit of saving first_name and last_name in the table. So in a scenario like this, we prefer to use the virtual column. Using Virtual Columns in Laravel Considering the first case, in Laravel to get virtual column i.e.  full_name  from the users table will have Accessors. Accessors are methods defined automatically called by Eloquent when select is called on that particular column. Let take an example here: To get full_...
Read more

How to Show Cookie Policy Consent or GDPR Popup in Laravel using Cookie.

-
Cookie in Laravel You can use the cookie in Laravel using the Helper method ` cookie() ` or method available with Request/Response Object or `Cookie` facade. $request->cookie('name'); OR use Illuminate\Support\Facades\Cookie; Cookie::get('name'); To get more clarity on how to use the cookie in Laravel with an example to show cookie consent popup on your Laravel website and hide/remove it once you accept the policy. Cookie Policy Consent Popup in Laravel First, create and a Cookie Consent popup as notification to the footer section of your Laravel main blade template file.  <div class="cookies-block">         <h5>This website uses cookies</h5>         <p>We use cookies to improve your experience and deliver personalised content. By using this website, you agree to our <a href="javascript:void()">Cookie Policy</a>.</p>         ...
Read more

Postman Collection Run - How to Test File Uploading API on CircleCi or Jenkins

-
Image
From last couple of days,  I was doing R&D on how we can test file uploading API on CircleCi or Postman collection Run? Finally, I found a way to test the File uploading APIs using the Postman Desktop app  OR Postman CLI collection run. I have also tested this solution, even on CircleCi for running the automated testing postman APIs by Postman CLI collection run. Here is step by step process, how you can test the file uploading API on CircleCi or Postman collection Run? Local Desktop App settings: Open and go to Local Postman app settings -> General Set working directly location  ( default is postman installation directory but can also choose any other directory ) Place files (to use in file upload APIs during the collection run) in the working directory selected as in the above step and also in the root directory of your project. Now go to the API in which you need to upload a file, and select the file from the working directory selected in step 2. Save that ...
Read more