系统环境

• Kubernetes版本：1.20.0

• Postgresql版本：14.0

部署Postgresql

[root@k8s01 bitbucket]# cat postgresql.yaml 
---
apiVersion: v1
kind: PersistentVolumeClaim
metadata:
  name: postgresql-data
  namespace: tools-env
spec:
  storageClassName: managed-nfs-storage
  accessModes:
  - ReadWriteOnce
  resources:
    requests:
      storage: 20Gi
---
kind: Service
apiVersion: v1
metadata:
  name: postgresql
  namespace: tools-env
  labels:
    name: postgresql
spec:
  ports:
    - name: postgres
      protocol: TCP
      port: 5432
      targetPort: postgres
  selector:
    name: postgresql
  type: ClusterIP
---
kind: Deployment
apiVersion: apps/v1
metadata:
  name: postgresql
  namespace: tools-env
  labels:
    name: postgresql
spec:
  replicas: 1
  selector:
    matchLabels:
      name: postgresql
  template:
    metadata:
      name: postgresql
      labels:
        name: postgresql
    spec:
      containers:
      - name: postgresql
        image: postgres:14.0
        ports:
        - name: postgres
          containerPort: 5432
        env:
        - name: POSTGRES_USER
          value: admin
        - name: POSTGRES_PASSWORD
          value: test-pwd
        - name: POSTGRES_DB
          value: postgresdb
        - name: DB_EXTENSION
          value: 'pg_trgm,btree_gist'
        resources: 
          requests:
            cpu: 2
            memory: 2Gi
          limits:
            cpu: 2
            memory: 2Gi
        livenessProbe:
          exec:
            command: ["pg_isready","-h","localhost","-U","postgres"]
          initialDelaySeconds: 30
          timeoutSeconds: 5
          periodSeconds: 10
          successThreshold: 1
          failureThreshold: 3
        readinessProbe:
          exec:
            command: ["pg_isready","-h","localhost","-U","postgres"]
          initialDelaySeconds: 5
          timeoutSeconds: 1
          periodSeconds: 10
          successThreshold: 1
          failureThreshold: 3
        volumeMounts:
        - name: data
          mountPath: /var/lib/postgresql
      volumes:
      - name: data
        persistentVolumeClaim:
          claimName: postgresql-data
[root@k8s01 gitlab]# kubectl apply -f postgresql.yaml 
persistentvolumeclaim/postgresql-data created
service/postgresql created
deployment.apps/postgresql created

变量说明：

数据库连接

root@postgresql-74755f975c-lxrmq:/# psql -h localhost -U admin --password -p 5432 postgresdb         
Password: 
psql (14.0 (Debian 14.0-1.pgdg110+1))
Type "help" for help.

#创建用户


postgresdb=# create user testuser with password '123456';
CREATE ROLE
#创建测试数据库
postgresdb=# CREATE DATABASE test;
CREATE DATABASE
#授权
postgresdb=# GRANT ALL PRIVILEGES ON DATABASE test TO testuser;
GRANT
postgresdb=#