79335013

Date: 2025-01-07 06:04:10
Score: 0.5
Natty:
Report link

Network

sudo docker network create local_central_db_network

create a file docker-compose.yml

version: '3.3'

services:
  postgres:
    image: postgres:16.4 # Using PostgreSQL version 16.4
    container_name: local-central-db-pgsql-container-16.4
    restart: always
    ports:
      - "5432:5432" # Expose port 5432 for external access
    environment:
      POSTGRES_USER: root # Replace with your username
      POSTGRES_PASSWORD: root # Replace with your password
    volumes:
      - ./dbdata:/var/lib/postgresql/data # Persist data between restarts
    networks:
      - local_central_db_network

networks:
  local_central_db_network:
    external: true

Command : Docker : Setup : Initialized

sudo docker-compose down
sudo docker-compose build && docker-compose up -d

Connect in command line

docker exec -it local-central-db-pgsql-container-16.4 bash
psql -U root
\q

Note: in clients use like this

enter image description here

Reasons:
  • Probably link only (1):
  • Long answer (-0.5):
  • Has code block (-0.5):
  • Low reputation (0.5):
Posted by: Md. Saifur Rahman