PostgreSQL Kubernetes Service

README.md

Create the Kubernetes service

curl -s https://gist.githubusercontent.com/nicerobot/fef144c9328b487e85f7a6ccbd5f70bc/raw/kubectl | bash -s -- apply

Run psql

bash -i <(curl -s https://gist.githubusercontent.com/nicerobot/fef144c9328b487e85f7a6ccbd5f70bc/raw/psql)

Remove the Kubernetes service

curl -s https://gist.githubusercontent.com/nicerobot/fef144c9328b487e85f7a6ccbd5f70bc/raw/kubectl | bash -s -- delete

kubectl

#!/usr/bin/env bash
kubectl ${1:-apply} -f https://gist.githubusercontent.com/nicerobot/fef144c9328b487e85f7a6ccbd5f70bc/raw/postgres.yml

postgres.yml

apiVersion: v1
kind: Service
metadata:
  name: db
  labels:
    app: db
spec:
  type: NodePort
  ports:
    - port: 5432
      targetPort: 5432
      name: db
  selector:
    app: db
---
apiVersion: apps/v1beta1
kind: Deployment
metadata:
  name: db
  labels:
    app: db
spec:
  template:
    metadata:
      labels:
        app: db
    spec:
      containers:
      - name: db
        image: postgres:10
        ports:
        - containerPort: 5432
          name: db

psql

#!/usr/bin/env bash
PGDATABASE=postgres
PGHOST=host.docker.internal
PGPASSWORD=postgres
PGPORT=$(kubectl get svc db -o jsonpath="{.spec.ports[0].nodePort}")
PGUSER=postgres

docker run --rm -it postgres:10 psql -h ${PGHOST} -p ${PGPORT} ${PGDATABASE} ${PGUSER}