Minikube部署PostGIS Pod显示运行但psql连接失败求助

在Debian 11系统中，将原Docker Compose部署的PostGIS实例迁移至Minikube+CRIO的Kubernetes集群，所有资源显示正常运行，但psql连接Pod失败。

部署清单 #

Namespace #

apiVersion: v1
kind: Namespace
metadata:
  name: ecoemploi

ConfigMap #

apiVersion: v1
kind: ConfigMap
metadata:
  name: postgres-config
  namespace: ecoemploi
  labels:
    app: sources
data:
  POSTGRES_DB: postgresdb
  POSTGRES_USER: postgres
  POSTGRES_PASSWORD: postgres

Persistent Volume 和 Persistent Volume Claim #

kind: PersistentVolume
apiVersion: v1
metadata:
  name: postgres-pv-volume
  namespace: ecoemploi
  labels:
    type: local
    app: sources
spec:
  storageClassName: manual
  capacity:
    storage: 50Gi
  accessModes:
    - ReadWriteMany
  hostPath:
    path: "/mnt/data"

---

kind: PersistentVolumeClaim
apiVersion: v1
metadata:
  name: postgres-pv-claim
  namespace: ecoemploi
  labels:
    app: sources
spec:
  storageClassName: manual
  accessModes:
    - ReadWriteMany
  resources:
    requests:
      storage: 50Gi

PostGIS Deployment #

使用镜像postgis/postgis:14-3.3（与原Docker Compose一致）：

apiVersion: apps/v1
kind: Deployment
metadata:
  name: postgres
  namespace: ecoemploi
spec:
  replicas: 1
  selector:
    matchLabels:
      app: sources
  template:
    metadata:
      labels:
        app: sources
    spec:
      containers:
        - name: sources
          image: postgis/postgis:14-3.3
          imagePullPolicy: "IfNotPresent"
          ports:
            - containerPort: 5435
          envFrom:
            - configMapRef:
                name: postgres-config
          volumeMounts:
            - mountPath: /var/lib/postgresql/data
              name: ecoemploigis
      volumes:
        - name: ecoemploigis
          persistentVolumeClaim:
            claimName: postgres-pv-claim

Service #

apiVersion: v1
kind: Service
metadata:
  name: postgres
  namespace: ecoemploi
  labels:
    app: sources
spec:
  type: NodePort
  ports:
    - port: 5435
  selector:
    app: sources

资源状态检查 #

执行kubectl get all --namespace=ecoemploi显示所有资源正常：

kubectl get all --namespace=ecoemploi
NAME                            READY   STATUS    RESTARTS      AGE
pod/postgres-687c6f59f6-8fkb4   1/1     Running   2 (10h ago)   15h

NAME               TYPE       CLUSTER-IP     EXTERNAL-IP   PORT(S)          AGE
service/postgres   NodePort   10.98.16.113   <none>        5435:31956/TCP   15h

NAME                       READY   UP-TO-DATE   AVAILABLE   AGE
deployment.apps/postgres   1/1     1            1           15h

NAME                                  DESIRED   CURRENT   READY   AGE
replicaset.apps/postgres-687c6f59f6   1         1         1       15h

连接尝试与报错 #

执行连接命令：

kubectl exec -it pod/postgres-687c6f59f6-8fkb4 --namespace ecoemploi -- psql -h localhost -U postgres --password -p 5435 ecoemploigis

报错信息：

psql: error: connection to server at "localhost" (127.0.0.1), port 5435 failed: Connection refused
    Is the server running on that host and accepting TCP/IP connections?
connection to server at "localhost" (::1), port 5435 failed: Cannot assign requested address
    Is the server running on that host and accepting TCP/IP connections?
command terminated with exit code 2

进入Pod内部，/var/log/postgresql/目录为空，无有效日志。首次部署Kubernetes，询问是否遗漏关键配置。

1. 修正端口配置不匹配问题 #

PostgreSQL默认监听端口是5432，你的Deployment和Service中配置了5435，但未通过环境变量告知PostgreSQL使用该端口。PostGIS镜像继承自官方PostgreSQL镜像，默认使用5432端口，需手动指定修改。

修复方式二选一：

• 将Deployment和Service中的端口改为5432；
• 在ConfigMap中添加PGPORT环境变量，让PostgreSQL启动时监听5435端口：

  apiVersion: v1
  kind: ConfigMap
  metadata:
    name: postgres-config
    namespace: ecoemploi
    labels:
      app: sources
  data:
    POSTGRES_DB: postgresdb
    POSTGRES_USER: postgres
    POSTGRES_PASSWORD: postgres
    PGPORT: "5435"
  

2. 验证PostgreSQL实际启动状态 #

Pod显示Running不代表内部服务正常，执行以下命令查看容器日志：

kubectl logs postgres-687c6f59f6-8fkb4 --namespace ecoemploi

日志中可能会暴露端口不匹配、数据目录权限异常等问题，针对性修复即可。

3. 修复Persistent Volume权限问题 #

使用hostPath类型PV时，Minikube节点上的/mnt/data目录权限可能不符合PostgreSQL运行要求（容器内默认使用postgres用户，UID为999）。进入Minikube节点修改权限：

minikube ssh
sudo chown -R 999:999 /mnt/data

4. 简化连接命令测试 #

在Pod内部执行psql时，可省略TCP/IP连接参数，直接通过Unix socket连接：

kubectl exec -it postgres-687c6f59f6-8fkb4 -n ecoemploi -- psql -U postgres postgresdb

这种方式能快速验证数据库是否正常运行。

内容的提问来源于stack exchange，提问作者Marc Le Bihan