Back to Browse

Local Development Set-Up of PostgreSQL with Docker

2.6K views
Jun 6, 2021
11:33

Postgres and pgadmin local setup using docker. How to use Postgres using docker? PgAdmin setup using docker Postgresql and pgAdmin dev environment setup using docker https://hub.docker.com/_/postgres https://hub.docker.com/r/dpage/pgadmin4 Blog post: https://medium.com/techwasti/postgres-pgadmin-development-environment-setup-with-docker-5d5dcff7b45b Steps 1. Postgresql docker container running 2. Postgresql container using CLI 3. pgadmin UI docker container to access it $ docker pull postgres:latest Blog http://techwasti.com/ Medium Publication https://medium.com/techwasti/ $ docker run --name pgsql -p 5432:5432 -e POSTGRES_PASSWORD=pass -d postgres Verify a new container created and running at 0.0.0.0:5432 with the below command. $ docker ps -a CLI docker exec -it pgsql bash psql -h localhost -p 5432 -U postgres verification query $ select CURRENT_DATE; Note:- pgadmin is not an official image and not a verified publisher as well $ docker pull dpage/pgadmin4 $ docker run --rm -p 80:80 -e [email protected] -e PGADMIN_DEFAULT_PASSWORD=pass --name dev-pgadmin -d dpage/pgadmin4 http://localhost:80/ $ docker inspect pgsql -f "{{json .NetworkSettings.Networks }}" ipaddress = 172.17.0.2 default username = postgres verification sql query $ select CURRENT_DATE;

Download

0 formats

No download links available.

Local Development Set-Up of PostgreSQL with Docker | NatokHD