Create AWS EC2 Instance | Install Postgres DB in AWS Cloud EC2 Server

In this video we will learn AWS cloud EC2 virtual machine setup from beginning and install postgres database in EC2 server.

1.????Create aws linux EC2 instance in AWS cloud from AWS management console.

2.????Adding firewall rule in the security group to open postgres db port.

3.????Connect to EC2 instance from local terminal using secret key pair.

4.????Download postgres database in AWS EC2 instance.

5.????Install postgres database in AWS EC2 instance.

6.????Update postgres db configuration to accept connection from remote machines.

7.????Connect postgres database in AWS EC2 instance from local machine

8.????Create schema and table in postgres database in AWS EC2 server.

9.????Insert data in postgres table in AWS EC2 server.

10. Query data from postgres table in AWS EC2 server.

** Introduction of AWS EC2 Instance **

Amazon Elastic Compute Cloud (Amazon EC2) provides scalable computing capacity in the Amazon Web Services (AWS) Cloud. Using Amazon EC2 eliminates your need to invest in hardware up front, so you can develop and deploy applications faster. You can use Amazon EC2 to launch as many or as few virtual servers as you need, configure security and networking, and manage storage. Amazon EC2 enables you to scale up or down to handle changes in requirements or spikes in popularity, reducing your need to forecast traffic.

** Benefits of AWS EC2 Instance **

AWS enables you to select the operating system, programming language, web application platform, database, and other services you need. With AWS, you receive a virtual environment that lets you load the software and services your application requires. Using Amazon EC2 eliminates your need to invest in hardware up front, so you can develop and deploy applications faster. You can use Amazon EC2 to launch as many or as few virtual servers as you need, configure security and networking, and manage storage.

** Postgres Database **

PostgreSQL or Postgres is the most commonly used open-source relational database. It offers features like robustness, reliability, cost-free, etc. PostgreSQL serves as a data warehouse for multiple applications like web apps, mobile apps, etc. It enables us to store enormous and sophisticated data securely. PostgreSQL is a powerful, open-source object-relational database system with over 35 years of active development that has earned it a strong reputation for reliability, feature robustness, and performance. PostgreSQL is used as the primary data store or data warehouse for many web, mobile, geospatial, and analytics applications. PostgreSQL is a traditional RDBMS (relational database management system) SQL database, like Oracle and MySQL.

** Topics Covered **

1.????Introduction to AWS Cloud EC2 Server Setup.

2.????Explained EC2 and Postgres Database Architecture ?

3.????Creating AWS linux EC2 server from AWS management console.

4.????Adding firewall rule in security setting to open postgres db port.

5.????Connect to AWS EC2 server from local terminal using secret key pair.

6.????Download postgres database in EC2 instance.

7.????Install postgres database in EC2 instance.

8.????Update postgres db configuration to accept connection from remote machines.

9.????Connect postgres database in AWS EC2 instance from local machine

10. Create schema and table in postgres database in AWS EC2 server.

11. Insert data in postgres table in AWS EC2 server.

12. Query data from postgres table in AWS EC2 server.

** Chapter Timestamps **

0:00 Welcome to AWS EC2 sever setup with Postgres DB

0:47 Agenda of this tutorial

1:27 AWS Cloud EC2 Architecture with Postgres DB

2:42 Create and Configure AWS Cloud EC2 Instance

8:16 Connect to AWS EC2 Instance from Local Putty tool

10:33 Download and Install Postgres DB in AWS EC2 Server

13:55 Update Postgres DB Config to allow Remote Connection

18:05 Connect Postgres DB in AWS EC2 from local Mongo Compass tool

20:51 Create Schema and Table in Postgres DB in AWS EC2 Instance

22:03 Insert Data in Postgres DB in AWS EC2 Server

22:30 Query Data from Postgres DB in AWS EC2 Server

23:23 Summary of this Tutorial

?

?

#postgres #aws #cloud ?

?

** CHECK OUT OUR OTHER VIDEOS **

Create AWS EC2 Instance and Running Springboot Microservice in EC2: https://youtu.be/TLuuf4UsiXA

Create AWS EC2 Instance and Install MongoDB AWS EC2 Server:

https://youtu.be/Gz_7WMjv6sE

Create AWS EC2 Install and Install MongoDB and Run Microservice in AWS EC2 Server:

https://youtu.be/FI2M61Cotpw

Spring boot project setup: https://youtu.be/bsgA20eJKxs

Spring Boot Microservice with postgres database Project: ?https://youtu.be/iw4wO9gEb50

Prepare Docker file, Container and Build Image: https://youtu.be/g_pdTzjnuso

Deploy Docker Image AWS Elastic Container Service: https://youtu.be/ZlR5onuwZzw

Run MongoDB in Docker Container: https://youtu.be/r4Yl4SO1BiA

?

** CHECK OUR PLAYLISTS **

Spring Boot Complete Tutorial https://youtube.com/playlist?list=PL2NZAYdLkYvg_VlNmszrb-Um0wRx5yGDF

Cloud & Container Tutorial with AWS Cloud and Docker Containers https://youtube.com/playlist?list=PL2NZAYdLkYvhZQo2VTVCSug_zVjekNodi

Java Design Pattern Complete Tutorial https://youtube.com/playlist?list=PL2NZAYdLkYvglL0xl-4tgBAribrcjeuNH

GITHUB Repository Tutorial | Complete Guide to GITHUB for Beginners

https://www.youtube.com/playlist?list=PL2NZAYdLkYvh5inIifHYlpAX10IE3vVGS

??

** ABOUT OUR CHANNEL **

CodeOneDigest is a youtube channel that produces videos on programming languages, cloud and container technologies, Software design principles, Java frameworks in English and Hindi languages.

Dosto, CodeOneDigest youtube channel pe aapko programming languages, container technology, cloud computing, software engineering se related videos milenge.

Check out our channel here:

https://www.youtube.com/channel/UC9V0QYsWKz_OD2uooCtEtRg

Don’t forget to subscribe!

** OUR WEBSITE **

https://codeonedigest.wordpress.com/

** GET IN TOUCH **

Email us on [email protected]

FOLLOW US ON SOCIAL - LIKE, SHARE & SUBSCRIBE

Get updates or reach out to Get updates on our Social Media Profiles!

Subscribe: https://bit.ly/3NeWQ8U

Youtube: https://www.youtube.com/channel/UC9V0QYsWKz_OD2uooCtEtRg

Twitter: https://twitter.com/codeonedigest

Facebook: https://www.facebook.com/codeonedigest

Instagram: https://www.instagram.com/codeonedigest/

Linkedin: https://www.dhirubhai.net/in/codeone-digest-10b418255/

Reddit: https://www.reddit.com/user/codeonedigest

Github: https://github.com/codeonedigest

Website: https://codeonedigest.wordpress.com/

Tumblr: https://www.tumblr.com/codeonedigest

Pinterest: https://in.pinterest.com/codeonedigest/