0:58

🧩 / PostgreSQL / Query

KindDescriptionPricing
UnitExecute SQL query against a PostgreSQL databaseFREE

Introduction

This integration allows you to schedule SQL queries against a PostgreSQL database.

Usage

This integration is distributed as an Helm chart. To install it, first add the following repository:

$ helm repo add link-society-incubator https://charts.link-society.com/incubator
$ helm repo update

Values

ValueDefaultDescription
scheduleevery 5 minutesDesired scheduling for the query
labels{}Map of labels to add to the Unit
dbmspostgresType of database to query. SHOULD NOT BE CHANGED
querySELECT 1Query to execute
cliArgs-Additional arguments to pass to the PostgreSQL client
secretNamekubirds-sql-unit-dbms-credentialsName of the Kubernetes Secret containing the database credentials
image.postgres.namepostgresDocker image name
image.postgres.taglatestDocker image tag
image.postgres.pullPolicyIfNotPresentKubernetes pull policy for the Docker image
serviceAccount.createtrueIf true, create the unit’s Kubernetes ServiceAccount
serviceAccount.annotations{}Additional annotations to add to the new ServiceAccount
serviceAccount.name-If not provided, will be set to default if serviceAccount.create is false, or to the chart’s full name if it is true

Credentials

The credentials information are given via a Kubernetes Secret with the following keys:

KeyDescription
DATABASE_HOSTDBMS Hostname
DATABASE_NAMEDatabase name
DATABASE_USERUsername
DATABASE_PASSWORDPassword

Setup

Install the unit with the following command:

$ helm install postgres-availability link-society-incubator/kubirds-sql-unit \
    --namespace default \
    --set schedule="every 5 minutes" \
    --set dbms="postgres" \
    --set secretName="pg-credentials"