Skip to content

README.md

Latest commit

 

History

History
79 lines (57 loc) · 2.48 KB

README.md

File metadata and controls

79 lines (57 loc) · 2.48 KB

Use and Seed SAP BTP PostgreSQL in SAP BTP, Kyma Runtime

Overview

Note

This sample is used in the Use and Seed SAP BTP PostgreSQL in SAP BTP, Kyma Runtime tutorial.

This sample seeds a managed PostgreSQL instance on SAP BTP with a small orders table. You use the provided postgres-instance-binding.yaml to create a PostgreSQL Service Instance and Service Binding for your Kyma cluster. The Service Binding produces a Kubernetes Secret containing the connection details (hostname, port, dbname, username, password, and optionally sslmode).

The sample demonstrates how to:

  • Prepare a Kyma namespace for consuming a BTP-managed PostgreSQL instance.
  • Seed the database using a Kubernetes Job that runs psql against the bound instance.

The SQL used to create and seed the table lives inline in the ConfigMap in database-postgres/k8s/seed-job.yaml.

Prerequisites

  • SAP BTP, Kyma runtime instance
  • kubectl configured to use the KUBECONFIG file downloaded from the Kyma runtime

Deploy the Sample

  1. Create and label a dev namespace if it does not exist:

    kubectl create namespace dev
kubectl label namespace dev istio-injection=enabled

  2. Use the provided postgres-instance-binding.yaml manifest to create the PostgreSQL instance and binding:

    kubectl -n dev apply -f ./k8s/postgres-instance-binding.yaml

  3. Apply the ConfigMap and Job that seeds the database:

    kubectl -n dev apply -f ./k8s/seed-job.yaml

  4. Wait for the Job to finish:

    kubectl -n dev get jobs seed-postgresql

  5. (Optional) Verify the data using a temporary psql client Pod. Replace postgresql-credentials with your binding Secret name if it differs:

    kubectl -n dev apply -f - <<'EOF'
apiVersion: v1
kind: Pod
metadata:
  name: pg-client
spec:
  restartPolicy: Never
  containers:
  - name: psql
    image: postgres:15
    envFrom:
    - secretRef:
        name: postgresql-credentials
    command: ["psql"]
    args: ["-v", "ON_ERROR_STOP=1", "-c", "SELECT order_id, description, created FROM orders;"]
EOF
kubectl -n dev logs pod/pg-client
kubectl -n dev delete pod/pg-client

Cleanup

Delete the seeding assets if you no longer need them:

kubectl -n dev delete job seed-postgresql
kubectl -n dev delete configmap postgresql-sample-sql