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
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