filmov
tv
Run Postgres Database in Docker Container | Postgres Docker Container Tutorial

Показать описание
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. Memento Design pattern defines three roles for objects.
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.
** Running Postgres database in Docker Container **
Containers offer easy app usage and scalability. Docker is a tool to create, deploy, and run applications using containers easily. A container is a standard unit of software that can be used to package applications and all the dependencies to a single package. These containers can be run on any server platform regardless of the underlying configuration or hardware structure. Docker can be used to run postgres database instances.
Docker image or containerization is the first step to take your application to cloud. The purpose of containerized application is to make sure your application is up and running always. Cloud platforms like AWS, AZURE or Google Cloud etc. provides container service to run docker image (containerized application).
Benefits of containerized application is we can scale up or scale down the number of instances (pods) in few seconds. Containerized applications run in PODs (containers) that is virtualization of operating system running on physical servers. Cloud services like AWS, Azure, GCP etc. ensure that PODs are always running and automatically recover from error. If any POD (application container) goes down then container service brings it up automatically without impacting the user traffic and performance.
** Connect Postgres Database with PGAdmin or DBeaver Database tool **
1. Open pgadmin or Dbeaver database tool.
2. In the left pane, create a connection to database by providing database url, port, database name, username, password information.
3. Click connect to connect to database.
** TIMESTAMPS **
0:00 Introduction Docker, DockerHub & Postgres Database
1:12 Design Architecture Diagram
3:46 Tools Requirements and Download
5:03 Prerequisite
5:21 Docker and DockerHub Introduction
6:59 Difference Docker Container vs Virtual Machine
9:02 Pull Postgres Image from DockerHub
11:52 Run Postgres Image in Docker Container
15:58 Connect Dbeaver to Postgres Database
19:26 Create Schema and Table in Postgres Database
21:20 Insert data and Query data in Postgres Table
23:52 Summary
#docker #postgres #database
** Tools **
** CHECK OUT OUR OTHER VIDEOS **
** CHECK OUR PLAYLISTS **
Docker Containers Complete Tutorial
GITHUB Repository Tutorial | Complete Guide to GITHUB for Beginners
How to do guide for Beginners
Http Methods & Http Status Codes
** 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.
Check out our channel here:
Don’t forget to subscribe!
** OUR WEBSITE **
** GET IN TOUCH **
FOLLOW US ON SOCIAL - LIKE, SHARE & SUBSCRIBE
Get updates or reach out to Get updates on our Social Media Profiles!
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.
** Running Postgres database in Docker Container **
Containers offer easy app usage and scalability. Docker is a tool to create, deploy, and run applications using containers easily. A container is a standard unit of software that can be used to package applications and all the dependencies to a single package. These containers can be run on any server platform regardless of the underlying configuration or hardware structure. Docker can be used to run postgres database instances.
Docker image or containerization is the first step to take your application to cloud. The purpose of containerized application is to make sure your application is up and running always. Cloud platforms like AWS, AZURE or Google Cloud etc. provides container service to run docker image (containerized application).
Benefits of containerized application is we can scale up or scale down the number of instances (pods) in few seconds. Containerized applications run in PODs (containers) that is virtualization of operating system running on physical servers. Cloud services like AWS, Azure, GCP etc. ensure that PODs are always running and automatically recover from error. If any POD (application container) goes down then container service brings it up automatically without impacting the user traffic and performance.
** Connect Postgres Database with PGAdmin or DBeaver Database tool **
1. Open pgadmin or Dbeaver database tool.
2. In the left pane, create a connection to database by providing database url, port, database name, username, password information.
3. Click connect to connect to database.
** TIMESTAMPS **
0:00 Introduction Docker, DockerHub & Postgres Database
1:12 Design Architecture Diagram
3:46 Tools Requirements and Download
5:03 Prerequisite
5:21 Docker and DockerHub Introduction
6:59 Difference Docker Container vs Virtual Machine
9:02 Pull Postgres Image from DockerHub
11:52 Run Postgres Image in Docker Container
15:58 Connect Dbeaver to Postgres Database
19:26 Create Schema and Table in Postgres Database
21:20 Insert data and Query data in Postgres Table
23:52 Summary
#docker #postgres #database
** Tools **
** CHECK OUT OUR OTHER VIDEOS **
** CHECK OUR PLAYLISTS **
Docker Containers Complete Tutorial
GITHUB Repository Tutorial | Complete Guide to GITHUB for Beginners
How to do guide for Beginners
Http Methods & Http Status Codes
** 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.
Check out our channel here:
Don’t forget to subscribe!
** OUR WEBSITE **
** GET IN TOUCH **
FOLLOW US ON SOCIAL - LIKE, SHARE & SUBSCRIBE
Get updates or reach out to Get updates on our Social Media Profiles!
Комментарии