Postgres On Docker | Postgres For Beginners | Postgres Docker Persistent Storage | pgAdmin

#PostgreSQL, #Docker, #Databases Hello Friends, Welcome back to my channel. In this tutorial we are going to see how we can run postgreSQL database in docker . We will see how we can create as simple docker instance for the database and also how to use environmental variables to set user name, password and database. We will also see how to connect to the database in the docker container , also through pgAdmin GUI in windows machine.

------------------------------------------------------------------------------------------------
How to setup docker in Centos:
https://youtu.be/HZnLhpkc0s8
--------------------------------------------------------------------------------------------
-----------------------------------------------------------------------------------------
MongoDB on docker:
https://youtu.be/7KYOjxu7Osk
------------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
References:
https://www.postgresql.org/ftp/pgadmin/pgadmin4/v4.22/windows/
https://hub.docker.com/_/postgres
-----------------------------------------------------------------------------------------
----------------------------------------------------------------------------------------
docker run -d --name postgresdb -e POSTGRES_USER=postgresuser -e POSTGRES_PASSWORD=password postgres

docker run -d --name postgresdb -p 5432:5432 -e POSTGRES_USER=postgresuser -e POSTGRES_PASSWORD=password -e POSTGRES_DB=newdb -v postgres_data:/var/lib/postgresql/data postgres

psql -U postgres

psql -d newdb -U postgresuser -W

\l

create database newdb;

\c newdb

\q
---------------------------------------------------------------------------------------------
---------------------------------------------------------------------------------------------
Firewall excemptions:
sudo firewall-cmd --permanent --zone=public --add-port=5432/tcp
sudo firewall-cmd --reload
------------------------------------------------------------------------------------------------
================================================
Follow me @:
https://www.instagram.com/thetips4you
https://www.instagram.com/thetipsforyou
https://www.youtube.com/channel/UCoOq-DtESvayx5yJE5H6-qQ
https://www.facebook.com/thetipsforyou
http://www.thetips4you.com
==================================================