PostgreSQL

May 9 2020

Importing data from a CVS file to a Amazon RDS PostgreSQL 12.2 using a SSH tunnel created in Python

In this post I will show you a simple python program that import a CVS file from a remote PC into a table of Amazon RDS PostgreSQL using a a SSH tunnel created by the same Python program. I going to use an Amazon RDS PostgreSQL without a Public IP, for this reason I will use an Amazon EC2 instance as bastion host (Jump server). Both Amazon RDS PostgreSQL and EC2 Instance use the same VPC (172.31.0.0/16) and the EC2 Read More

By • Amazon RDS, Amazon Web Services (AWS), Cloud, PostgreSQL, Programming Languages, Python • 0

Apr 21 2020

Install Oracle GoldenGate 12c for PostgresSQL 12.2 in AWS EC2 RHEL 8

In this post I will install GoldenGate 12c for PostgreSQL 12.2 in AWS EC2 in Red Hat Linux 8. I going to install Oracle GoldenGate 12c with the below specifications: Operating System: Red Hat Enterprise Linux release 8.0 (Ootpa) Database: Postgress 12.2 GoldenGate version: 12.2.0.2.2 GoldeGate installer: 122022_ggs_Linux_x64_PostgreSQL_64bit.zip 1. Create the GoldenGate Home directory and setup the environment variable ($GGH) 2. Download Oracle GoldenGate 10.1.0.0.4 for Oracle (64 bits) 122022_ggs_Linux_x64_PostgreSQL_64bit.zip from Oracle website. 3. Transfer the zip file 122022_ggs_Linux_x64_PostgreSQL_64bit.zip to Read More

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

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