PostgreSQL - Docker 部署

简介

使用 Docker 部署 PostgreSQL 数据库。

前置条件

• Docker 已安装。 【参考链接】

详细步骤

第一步： 配置 .pega_db_env ，根据自身的需求进行变更

POSTGRES_USER=postgres
POSTGRES_PASSWORD=postgres
POSTGRES_DB=postgres

第二步： 配置 docker-compose.yaml

networks:
  postgres-net:
    driver: bridge
    ipam:
      driver: default
      config:
        - subnet: 172.2.0.0/16
          gateway: 172.2.0.1

services:
  pega-db:
    image: postgres:15.4
    container_name: pega-db
    ports:
      - "30054:5432"
    env_file:
      - .pega_db_env
    volumes:
      - ./data/postgres/var/lib/postgresql/data:/var/lib/postgresql/data
    networks:
      - postgres-net
    restart: unless-stopped

第三步： 启动容器

myserver@pega-minikube-poc:~/pega/postgres$ docker compose up -d
[+] Running 2/2
 ✔ Network postgres_postgres-net  Created      
 ✔ Container pega-db              Started

第四步： 查看 docker 容器

myserver@pega-minikube-poc:~/pega/postgres$ docker container ls -a
e452f78557b2   postgres:15.4                   "docker-entrypoint.s…"   2 minutes ago    Up 2 minutes    0.0.0.0:30054->5432/tcp, [::]:30054->5432/tcp                                                                                          pega-db

第五步： 查看启动日志

myserver@pega-minikube-poc:~/pega/postgres$ docker logs -f --tail 10 pega-db
server stopped

PostgreSQL init process complete; ready for start up.

2025-02-19 09:13:39.033 UTC [1] LOG:  starting PostgreSQL 15.4 (Debian 15.4-2.pgdg120+1) on x86_64-pc-linux-gnu, compiled by gcc (Debian 12.2.0-14) 12.2.0, 64-bit
2025-02-19 09:13:39.034 UTC [1] LOG:  listening on IPv4 address "0.0.0.0", port 5432
2025-02-19 09:13:39.034 UTC [1] LOG:  listening on IPv6 address "::", port 5432
2025-02-19 09:13:39.069 UTC [1] LOG:  listening on Unix socket "/var/run/postgresql/.s.PGSQL.5432"
2025-02-19 09:13:39.092 UTC [64] LOG:  database system was shut down at 2025-02-19 09:13:38 UTC
2025-02-19 09:13:39.107 UTC [1] LOG:  database system is ready to accept connections

以上便是本文的全部内容，感谢您的阅读。