# 檢查 Docker 是否安裝
sudo docker --version

# 檢查 Docker 服務是否運行
sudo systemctl status docker

# 拉取測試鏡像
sudo docker pull hello-world

sudo mkdir -p /etc/docker
sudo vim /etc/docker/daemon.json

{
"registry-mirrors": [
"https://docker.m.daocloud.io",
"https://docker.1ms.run",
"https://docker.anyhub.us.kg"
],
"dns": ["223.5.5.5", "114.114.114.114"]
}

sudo systemctl daemon-reload

sudo systemctl restart docker

# 拉取官方 PostgreSQL 15.4 鏡像
sudo docker pull postgres:15.4

# 驗證鏡像是否下載成功
sudo docker images postgres:15.4

# 創(chuàng)建存儲目錄
sudo mkdir -p /opt/postgresql/data
# 設置權限（必須）
sudo chown -R 999:999 /opt/postgresql/data

# 一鍵創(chuàng)建并啟動容器
sudo docker run -d \
--name postgres_db \
--restart unless-stopped \
-e POSTGRES_USER=postgres \
-e POSTGRES_PASSWORD=postgres \
-e POSTGRES_DB=postgres \
-p 5432:5432 \
-v /opt/postgresql/data:/var/lib/postgresql/data \
postgres:15.4

# 查看容器是否啟動成功
sudo docker ps | grep postgres_db

# 進入容器內部
sudo docker exec -it postgres_db psql -U postgres

#版本顯示
SELECT version();

\l

\q

# 修改配置允許遠程連接
sudo docker exec -it postgres_db bash -c "echo \"host all all 0.0.0.0/0 md5\" >> /var/lib/postgresql/data/pg_hba.conf"
# 重啟容器生效
sudo docker restart postgres_db

# 啟動容器
sudo docker start postgres_db
# 停止容器
sudo docker stop postgres_db
# 查看容器日志
sudo docker logs -f postgres_db
# 進入容器 bash
sudo docker exec -it postgres_db bash

# 進入容器內部連接數據庫
sudo docker exec -it postgres_db psql -U postgres

pip install psycopg2-binary

#text01.py
import psycopg2
try:
conn = psycopg2.connect(
host="192.168.1.128",
port="5432",
database="postgres",
user="postgres",
password="postgres"
)
print("連接成功！")
cursor = conn.cursor()
cursor.execute("SELECT version();")
print("PostgreSQL 版本:", cursor.fetchone())
cursor.close()
conn.close()
except Exception as e:
print("連接失敗:", e)

python test01.py