Docker Deployment

Installing PostgreSQL using Docker Desktop

Time requirement: 10 mins

Install Docker Desktop (if not already available)

Mac Install Notes / Win Install Notes

Summary:

1. download package from official Docker release notes page
2. Accept license and proceed with installation
3. Optionally review Docker Desktop explorer tutorial

Deploy Postgres-17 install and expose ports

• Download latest Postgres “container”:
  $ docker pull postgres:latest

• or install specific/named version:
  $ docker pull postgres:17.4

Launch Postgres Container with exposed port

docker run -d --name pgdemo -p 5432:5432 -e POSTGRES_PASSWORD=DefaultPassword postgres:latest

or for named postgres version:

docker run -d --name pgdemo -p 5432:5432 -e POSTGRES_PASSWORD=DefaultPassword postgres:17.4

“-d” is for detached session, “-e” are for environment variables

Connect to local Postgres Instance

• Using Docker session in docker environment:
  docker exec -it pgdemo psql -U postgres -d postgres

• Using exposed port with local shell access:
  psql -h localhost -U "postgres" -d postgres

References

• official docs
  
• user content