March 2020

Mar 28 2020

Install pgAdmin 4.19 and setup a SSH tunnel to access to AWS EC2 PostgreSQL database.

In this post will show you how install pgAdmin 4.19 for Windows and how configure postgreSQL 12.2 to be accessed by pgAdmin ussing SSH. If you do not have a AWS EC2 instance you can go to my post: Launch and setup a free tier AWS EC2 instance with Red Hat Enterprise Linux 8. If you did not install PostgresSQL Server yet you can go to my post: Install PostgreSQL Server 12.2 on RHEL 8 1. Go to PostgreSQL home Read More

By • Amazon Web Services (AWS), Cloud, Databases, PostgreSQL, Tools • 0

Mar 27 2020

Install PostgreSQL Server 12.2 on RHEL 8

In this post we are going to install PostgreSQL Server version 12.2 on Red Hat Enterprise Linux 8, this PostgreSQL server will be used for the next posts about migration of data between different databases. 1. We are going to check if a previous version of PostgreSQL Server was installed in the Linux Server. 2. Because PostgreSQL version 10.6 was installed previously we are going to remove it from the server. 3. Install the repository RPM . 4. Disable the Read More

By • Databases, PostgreSQL • 0

Mar 23 2020

Launch and setup a free tier AWS EC2 instance with Red Hat Enterprise Linux 8.

In this post I will explain the steps to configure a free tier AWS EC2 instance with Red Hat Enterprise Linux 8 and how to access it through SSH. 1. Create and activate a new Amazon Web Services account. a. Go to  Amazon Web Services home page b. Follow the steps explained by Amazon to create and activate a new Amazon Web Services account 2. Launch a new instance Click on Services > EC2 > Instances > Launch Instance a. Read More

By • Amazon Web Services (AWS), Cloud • 0

Mar 17 2020

Migrate an on-premises Oracle database to Oracle on Amazon EC2 using AWS DMS

There are many ways to migrate on premises Oracle database to Elastic Compute Cloud (EC2). In this post I will show how to use AWS Database Migration Service to migrate on-premises Oracle Database 12.1.0 running in Windows to AWS EC2 running in Linux. I installed locally Oracle 12c software in Windows environment and created manually a new Oracle database 12.1.0 (SID SRCDB) then installed the Sample Schemas/Users that populate data in the new schemas: IX , SH , OE , Read More

By • Amazon Web Services (AWS), AWS Database Migration Services, Cloud, Databases, Migration, Oracle • 0