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

codeonedigest
codeonedigest
3.8 هزار بار بازدید - پارسال - In this video we will
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.

** 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: Amazon EC2 Instance Setup and Running...
Create AWS EC2 Instance and Install MongoDB AWS EC2 Server: AWS EC2 Instance Setup and Run MongoD...
Create AWS EC2 Install and Install MongoDB and Run Microservice in AWS EC2 Server: AWS EC2 Instance Setup and Run Spring...
Spring boot project setup: Spring boot Project Step by Step Tuto...
Spring Boot Microservice with postgres database Project:  Spring Boot Microservice Project with...
Prepare Docker file, Container and Build Image: Docker Tutorial for Beginners | Creat...
Deploy Docker Image AWS Elastic Container Service: Deploy Springboot Microservice Docker...
Run MongoDB in Docker Container: Run MongoDB Image in Docker Container...

** CHECK OUR PLAYLISTS **
Spring Boot Complete Tutorial Spring Boot Tutorial with Project Set...
Cloud & Container Tutorial with AWS Cloud and Docker Containers Cloud & Container Tutorial with AWS C...
Java Design Pattern Complete Tutorial Java Design Patterns for Student | Ga...

 
** 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: @codeonedigest
Twitter: Twitter: codeonedigest
Facebook: Facebook: codeonedigest
Instagram: Instagram: codeonedigest
Github: https://github.com/codeonedigest
Website: https://codeonedigest.wordpress.com/
Pinterest: Pinterest: codeonedigest
پارسال در تاریخ 1401/11/24 منتشر شده است.
3,807 بـار بازدید شده
... بیشتر