У нас вы можете посмотреть бесплатно Connect Database on EC2 to spring boot In 1 GO (Step by Step) или скачать в максимальном доступном качестве, видео которое было загружено на ютуб. Для загрузки выберите вариант из формы ниже:
Если кнопки скачивания не
загрузились
НАЖМИТЕ ЗДЕСЬ или обновите страницу
Если возникают проблемы со скачиванием видео, пожалуйста напишите в поддержку по адресу внизу
страницы.
Спасибо за использование сервиса ClipSaver.ru
How to Install and Connect PostgreSQL deployed on EC2 to spring boot and dbeaver | How to Install PostgreSQL in AWS EC2 | How to install PostgreSQL in EC2 instance | How to Install PostgreSQL in AWS EC2 in 3 Simple Steps [2025] This video provides a step-by-step guide on how to connect a database on an Amazon AWS EC2 instance to a Spring Boot application. We will cover the process of setting up a PostgreSQL database on an EC2 instance, installing pgadmin 4, and configuring the database connection. The tutorial also covers the installation of PostgreSQL on an EC2 instance, setting up a Postgresql database, and connecting to it using a tool like Dbeaver. By the end of this video, you will have a clear understanding of how to connect a PostgreSQL database on an EC2 instance to a Spring Boot application, and be able to run your application with a database on the AWS cloud. The video is designed to be a comprehensive Spring Boot tutorial, covering topics such as EC2 Postgresql setup, EC2 Postgresql run, and connecting Postgresql to a Spring Boot application. The tutorial is perfect for those looking for an AWS tutorial, or a Postgresql tutorial, and want to learn how to set up a database on an EC2 instance and connect it to a Spring Boot application. The video covers the process of installing Postgresql on an EC2 instance, setting up a Postgresql database, and connecting to it using a Linux server, making it a valuable resource for those looking to learn about database setup and configuration on the AWS cloud. --------------------- Chapters: 00:00 - 02:54 -Create and launch a EC2 instance 03:00 - 06:20 - Install the PostgreSQL 15 database 06:21- 07:52 - Connect to PostgreSQL DB from External Client 07:53- 15:00 - PostgreSQL and AWS Configuration and Dbeaver Connection 15:01- 17:10 - Spring boot Connection with PostgreSQL --------------------- Steps to install PostgreSQL in EC2: Step 1. Create and launch a EC2 instance Step 2. Install the PostgreSQL 15 database a. Update system packages sudo yum update -y b. Install PostgreSQL 15 sudo yum install postgresql15 postgresql15-server -y c. Initialize the database sudo postgresql-setup --initdb d. Start and enable the PostgreSQL service sudo systemctl start postgresql sudo systemctl enable postgresql Step 3. Connect to PostgreSQL DB and test Switch to the `postgres` user and access `psql` sudo su - postgres psql select * from pg_stat_activity; to list all databases \l to connect to database postgres \c postgres select * from pg_stat_activity; set password inside psql ALTER USER postgres WITH PASSWORD 'root'; Prerequesites: Download and install pgadmin or dbeaver Step 1: Connect to EC2 and verify the username database and password sudo su - postgres psql ALTER USER postgres WITH PASSWORD 'root'; Step 2: Update configuration of postgres a) update postgresql.conf to allows incoming connections on all available IP interfaces. listen_addresses = '*' b) update pg_hba.conf file to allow all ip to be authorized host all all 0.0.0.0/0 md5 :q to quit and :wq to save and exit from vi Step 3: Restart the postgresql sudo systemctl restart postgresql to check status sudo systemctl status postgresql Step 4: Update Security Group of AWS to allow 5432 port, add postgres rule in inbound rules Step 5: Test in Dbeaver or pgadmin Step 6: Test in springboot spring.datasource.url=jdbc:postgresql://(EC2-Public-IP):5432/(your_database) spring.datasource.username=postgres spring.datasource.password=(your_password) spring.datasource.driver-class-name=org.postgresql.Driver Optional: JPA settings spring.jpa.hibernate.ddl-auto=update spring.jpa.show-sql=true spring.jpa.properties.hibernate.dialect=org.hibernate.dialect.PostgreSQLDialect add dependencies a) spring-boot-starter-data-jpa b) postgresql #postgresqltutorial #postgres #postgresql #ec2 #aws #instance #database #cloud #cloudcomputing #awsdeveloper