| Kind | Description | Pricing |
|---|---|---|
| Unit | Execute SQL query against a PostgreSQL database | FREE |
This integration allows you to schedule SQL queries against a PostgreSQL database.
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
| Value | Default | Description |
|---|---|---|
schedule | every 5 minutes | Desired scheduling for the query |
labels | {} | Map of labels to add to the Unit |
dbms | postgres | Type of database to query. SHOULD NOT BE CHANGED |
query | SELECT 1 | Query to execute |
cliArgs | - | Additional arguments to pass to the PostgreSQL client |
secretName | kubirds-sql-unit-dbms-credentials | Name of the Kubernetes Secret containing the database credentials |
image.postgres.name | postgres | Docker image name |
image.postgres.tag | latest | Docker image tag |
image.postgres.pullPolicy | IfNotPresent | Kubernetes pull policy for the Docker image |
serviceAccount.create | true | If 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 |
The credentials information are given via a Kubernetes Secret with the following keys:
| Key | Description |
|---|---|
DATABASE_HOST | DBMS Hostname |
DATABASE_NAME | Database name |
DATABASE_USER | Username |
DATABASE_PASSWORD | Password |
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"