May 5 2020
Configure a SSH Tunnel using Putty to connect to a AWS EC2 instance.
In this post I will show you how configure a SSH Tunnel using Putty to connect to a AWS EC2 Instance with CentOS release 6.9 running Oracle 12c I will configure a SSH Tunnel to connect to a Oracle 12c database located in a EC2 instance that uses the default port 1521, If you wish you can configure other port like 5432 (default port for PostgreSQL) or 3306 (default port for MySQL) Steps to configure SSH Tunnel 1. Get the Read More
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 DBA_JAF • Amazon RDS, Amazon Web Services (AWS), Cloud, PostgreSQL, Programming Languages, Python • 0