PostgreSQL
The PostgreSQL connector provides connectivity to a PostgreSQL databases.
Example PostgreSQL catalog configuration
apiVersion: trino.stackable.tech/v1alpha1
kind: TrinoCatalog
metadata:
# The name of the catalog as it will appear in Trino
name: postgresql
# TrinoCluster can use these labels to select which catalogs to include
labels:
trino: simple-trino
spec:
connector:
postgresql:
host: my-postgresql
port: 5432 # defaults to 5432
database: mydatabase
credentialsSecretName: my-postgresql-credentials # Must provide the username and password keys
---
apiVersion: v1
kind: Secret
metadata:
name: my-postgresql-credentials
stringData:
username: myusername
password: mypassword