postgresql运维——docker快速搭建

version: '3.9'




services:




  db:
    image: postgres:16.2
    restart: always
    # set shared memory limit when using docker-compose
    shm_size: 128mb
    # or set shared memory limit when deploy via swarm stack
    #volumes:
    #  - type: tmpfs
    #    target: /dev/shm
    #    tmpfs:
    #      size: 134217728 # 128*2^20 bytes = 128Mb
    container_name: postgres-db
    volumes:
      - "./dbdata:/var/lib/postgresql/data"
    environment:
      POSTGRES_PASSWORD: puJ82en9yI336A
    ports:
     - "5433:5432"

docker run -itd --name=postgres-db \
        --volume=/data/postgres/dbdata:/var/lib/postgresql/data:rw \
        --volume=/data/postgres/postgresql.conf:/var/lib/postgresql/data/postgresql.conf:rw \
        -p 5432:5432 \
        -e POSTGRES_PASSWORD=JfxjF43v2w \
        --shm-size 128m \
        --restart=always \
        --runtime=runc \
        postgres:16.2_postgis \
        postgres