/
400-create-job.yaml
37 lines (37 loc) · 1.04 KB
/
400-create-job.yaml
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
apiVersion: batch/v1
kind: Job
metadata:
name: postgresql-job
spec:
ttlSecondsAfterFinished: 50
template:
spec:
containers:
- name: postgresql-client
image: quay.io/enterprisedb/postgresql
command: ["psql", "-h", "postgresql", "-U", "myuser", "-d", "mydatabase", "-f", "/sql/sample.sql"]
env:
- name: PGPASSWORD
valueFrom:
secretKeyRef:
name: postgresql-secret
key: POSTGRES_PASSWORD
- name: PGUSER
valueFrom:
secretKeyRef:
name: postgresql-secret
key: POSTGRES_USER
- name: PGDATABASE
valueFrom:
secretKeyRef:
name: postgresql-secret
key: POSTGRES_DB
volumeMounts:
- name: sql-volume
mountPath: /sql
restartPolicy: Never
volumes:
- name: sql-volume
configMap:
name: sql-configmap
backoffLimit: 5