Postgresql is one of the most widely used Open-source Databases in the modern Era. Millions of developers and companies believe that PostgreSQL as their transactional data store to drive application health and decision-making. And developers with knowledge of Oracle or MySQL databases can use their SQL querying experience to quickly leverage PostgreSQL’s capabilities as a quick, functional, and powerful data resource.
Today I am going to explain about Migration of Heroku PostgreSQL Database to AWS RDS PostgreSQL. I think most people are aware of the Heroku Cloud. Please clickhere to know more about Heroku Cloud.
We have several methods for performing this Migration. Today I am explaining Migration using the pg_dump and pg_restore method. I am using centos 7 Instance as a middle Instance for migration. You can use Windows, Mac or any System depends upon your easiness.
First, we need to install Heroku CLI on our Machine. Before that, we need to install git as a prerequisite:
yum install git
Now we can Install Heroku cli using below command,
curl<ahref="https://cli-assets.heroku.com/install.sh">https://cli-assets.heroku.com/install.sh</a> | sh
Please verify the Heroku cli version, once it installed
We have installed the Heroku cli successfully. Now we can install PostgreSQL client,