SGConfig

Kind: SGConfig

listKind: SGConfigList

plural: sgconfigs

singular: sgconfig

StackGres Operator configuration is stored in SGConfig Custom Resource.

WARNING: Creating more than one SGConfig is forbidden in order to avoid misbehaviours. The single SGConfig should be created automatically during installation.

Example:

apiVersion: stackgres.io/v1
kind: SGConfig
metadata:
  name: stackgres-operator
spec:
  # Default values copied from <project_dir>/helm-charts/stackgres-operator/values.yaml
  containerRegistry: quay.io
  imagePullPolicy: IfNotPresent
  operator:
    image:
      pullPolicy: IfNotPresent
  restapi:
    name: stackgres-restapi
    image:
      pullPolicy: IfNotPresent
  adminui:
    name: stackgres-adminui
    image:
      pullPolicy: IfNotPresent
    service:
      exposeHTTP: false
      type: ClusterIP
  jobs:
    name: stackgres-jobs
    image:
      pullPolicy: IfNotPresent
  authentication:
    type: jwt
    user: admin
  extensions:
    repositoryUrls:
    - https://extensions.stackgres.io/postgres/repository
  grafana:
    autoEmbed: false
    datasourceName: Prometheus
    password: prom-operator
    schema: http
    user: admin
  prometheus:
    allowAutobind: true

See also StackGres Installation section.

SGConfig stores the configuration of the StackGres Operator

WARNING: Creating more than one SGConfig is forbidden in order to avoid misbehaviours. The single SGConfig should be created automatically during installation.

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

apiVersion ✓ string stackgres.io/v1
kind ✓ string SGConfig
metadata ✓ ✓ object Refer to the Kubernetes API documentation for the fields of the metadata field.
spec ✓ object Spec defines the desired state of SGConfig
status ✓ object Status defines the observed state of SGConfig

SGConfig.spec

↩ Parent

Spec defines the desired state of SGConfig

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

adminui ✓ object Section to configure Web Console container
authentication ✓ object Section to configure Web Console authentication
cert ✓ object Section to configure the Operator, REST API and Web Console certificates and JWT RSA key-pair.
containerRegistry ✓ string The container registry host (and port) where the images will be pulled from.

Default: quay.io
deploy ✓ object Section to configure deployment aspects.
developer ✓ object Section to configure developer options.

Following options are for developers only, but can also be useful in some cases ;)

extensions ✓ object Section to configure extensions
grafana ✓ object Section to configure Grafana integration
imagePullPolicy ✓ string Image pull policy used for images loaded by the Operator

Default: IfNotPresent
jobs ✓ object Section to configure Operator Installation Jobs
operator ✓ object Section to configure Operator Pod
prometheus ✓ object Section to configure Prometheus integration.
rbac ✓ object Section to configure RBAC for Web Console admin user
restapi ✓ object Section to configure REST API Pod
serviceAccount ✓ object Section to configure Operator Installation ServiceAccount
shardingSphere ✓ object Section to configure integration with ShardingSphere operator

SGConfig.spec.adminui

↩ Parent

Section to configure Web Console container

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

image ✓ object Section to configure Web Console image
resources ✓ object Web Console resources. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#resourcerequirements-v1-core
service ✓ object Section to configure Web Console service.

SGConfig.spec.adminui.image

↩ Parent

Section to configure Web Console image

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

name ✓ string Web Console image name

Default: stackgres/admin-ui
pullPolicy ✓ string Web Console image pull policy

Default: IfNotPresent
tag ✓ string Web Console image tag

SGConfig.spec.adminui.service

↩ Parent

Section to configure Web Console service.

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

exposeHTTP ✓ boolean When set to true the HTTP port will be exposed in the Web Console Service

Default: false
loadBalancerIP ✓ string LoadBalancer will get created with the IP specified in this field. This feature depends on whether the underlying cloud-provider supports specifying the loadBalancerIP when a load balancer is created. This field will be ignored if the cloud-provider does not support the feature.
loadBalancerSourceRanges ✓ []string If specified and supported by the platform, this will restrict traffic through the cloud-provider load-balancer will be restricted to the specified client IPs. This field will be ignored if the cloud-provider does not support the feature. More info: https://kubernetes.io/docs/tasks/access-application-cluster/configure-cloud-provider-firewall/
nodePort ✓ integer The HTTPS port used to expose the Service on Kubernetes nodes
nodePortHTTP ✓ integer The HTTP port used to expose the Service on Kubernetes nodes
type ✓ string The type used for the service of the UI:

  • Set to LoadBalancer to create a load balancer (if supported by the kubernetes cluster) to allow connect from Internet to the UI. Note that enabling this feature will probably incurr in some fee that depend on the host of the kubernetes cluster (for example this is true for EKS, GKE and AKS).
  • Set to NodePort to expose admin UI from kubernetes nodes.

    Default: ClusterIP

SGConfig.spec.authentication

↩ Parent

Section to configure Web Console authentication

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

createAdminSecret ✓ boolean When true will create the secret used to store the admin user credentials to access the UI.

Default: true
oidc ✓ object Section to configure Web Console OIDC authentication
password ✓ string The admin password that will be created for the Web Console.

If not specified a random password will be generated.

secretRef ✓ object Allow to specify a reference to a Secret with the admin user credentials for the Web Console.

In order to assign properly permissions. Make sure the user field match the value of the k8sUsername key in the referenced Secret.

type ✓ string Specify the authentication mechanism to use. By default is jwt, see https://stackgres.io/doc/latest/api/rbac#local-secret-mechanism. If set to oidc then see https://stackgres.io/doc/latest/api/rbac/#openid-connect-provider-mechanism.

Default: jwt
user ✓ string The admin username that will be created for the Web Console

Operator bundle installation can not change the default value of this field.

Default: admin

SGConfig.spec.authentication.oidc

↩ Parent

Section to configure Web Console OIDC authentication

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

authServerUrl ✓ string
clientId ✓ string
clientIdSecretRef ✓ object
credentialsSecret ✓ string
credentialsSecretSecretRef ✓ object
tlsVerification ✓ string Can be one of required, certificate-validation or none
SGConfig.spec.authentication.oidc.clientIdSecretRef

↩ Parent

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

key ✓ string
name ✓ string
SGConfig.spec.authentication.oidc.credentialsSecretSecretRef

↩ Parent

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

key ✓ string
name ✓ string

SGConfig.spec.authentication.secretRef

↩ Parent

Allow to specify a reference to a Secret with the admin user credentials for the Web Console.

In order to assign properly permissions. Make sure the user field match the value of the k8sUsername key in the referenced Secret.

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

name ✓ string The name of the Secret.

SGConfig.spec.cert

↩ Parent

Section to configure the Operator, REST API and Web Console certificates and JWT RSA key-pair.

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

autoapprove ✓ boolean If set to true the CertificateSigningRequest used to generate the certificate used by Webhooks will be approved by the Operator Installation Job.

Default: true
certDuration ✓ integer The duration in days of the generated certificate for the Operator after which it will expire and be regenerated. If not specified it will be set to 730 (2 years) by default.
certManager ✓ object Section to configure cert-manager integration to generate Operator certificates
createForOperator ✓ boolean When set to true the Operator certificate will be created.

Default: true
createForWebApi ✓ boolean When set to true the Web Console / REST API certificate will be created.

Default: true
regenerateCert ✓ boolean When set to true the Operator certificates will be regenerated if createForOperator is set to true, and the certificate is expired or invalid.

Default: true
regenerateWebCert ✓ boolean When set to true the Web Console / REST API certificates will be regenerated if createForWebApi is set to true, and the certificate is expired or invalid.

Default: true
regenerateWebRsa ✓ boolean When set to true the Web Console / REST API RSA key pair will be regenerated if createForWebApi is set to true, and the certificate is expired or invalid.

Default: true
secretName ✓ string The Secret name with the Operator Webhooks certificate issued by the Kubernetes cluster CA of type kubernetes.io/tls. See https://kubernetes.io/docs/concepts/configuration/secret/#tls-secrets
webCertDuration ✓ integer The duration in days of the generated certificate for the Web Console / REST API after which it will expire and be regenerated. If not specified it will be set to 730 (2 years) by default.
webRsaDuration ✓ integer The duration in days of the generated RSA key pair for the Web Console / REST API after which it will expire and be regenerated. If not specified it will be set to 730 (2 years) by default.
webSecretName ✓ string The Secret name with the Web Console / REST API certificate of type kubernetes.io/tls. See https://kubernetes.io/docs/concepts/configuration/secret/#tls-secrets

SGConfig.spec.cert.certManager

↩ Parent

Section to configure cert-manager integration to generate Operator certificates

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

autoConfigure ✓ boolean When set to true then Issuer and Certificate for Operator and Web Console / REST API Pods will be generated

Default: false
duration ✓ string The requested duration (i.e. lifetime) of the Certificates. See https://cert-manager.io/docs/reference/api-docs/#cert-manager.io%2fv1

Default: 2160h
encoding ✓ string The private key cryptography standards (PKCS) encoding for this certificate’s private key to be encoded in. See https://cert-manager.io/docs/reference/api-docs/#cert-manager.io/v1.CertificatePrivateKey

Default: PKCS1
renewBefore ✓ string How long before the currently issued certificate’s expiry cert-manager should renew the certificate. See https://cert-manager.io/docs/reference/api-docs/#cert-manager.io%2fv1

Default: 360h
size ✓ integer Size is the key bit size of the corresponding private key for this certificate. See https://cert-manager.io/docs/reference/api-docs/#cert-manager.io/v1.CertificatePrivateKey

Default: 2048

SGConfig.spec.deploy

↩ Parent

Section to configure deployment aspects.

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

operator ✓ boolean When set to true the Operator will be deployed.

Default: true
restapi ✓ boolean When set to true the Web Console / REST API will be deployed.

Default: true

SGConfig.spec.developer

↩ Parent

Section to configure developer options.

Following options are for developers only, but can also be useful in some cases ;)

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

allowPullExtensionsFromImageRepository ✓ boolean If set to true and extensions.cache.enabled is also true it will try to download extensions from images (experimental)

Default: false
disableArbitraryUser ✓ boolean It set to true disable arbitrary user that is set for OpenShift clusters

Default: false
enableJvmDebug ✓ boolean Only work with JVM version and allow connect on port 8000 of operator Pod with jdb or similar

Default: false
enableJvmDebugSuspend ✓ boolean Only work with JVM version and if enableJvmDebug is true suspend the JVM until a debugger session is started

Default: false
externalOperatorIp ✓ string Set the external Operator IP
externalOperatorPort ✓ integer Set the external Operator port
externalRestApiIp ✓ string Set the external REST API IP
externalRestApiPort ✓ integer Set the external REST API port
logLevel ✓ string Set quarkus.log.level. See https://quarkus.io/guides/logging#root-logger-configuration
patches ✓ object Section to define patches for some StackGres Pods
showDebug ✓ boolean If set to true add extra debug to any script controlled by the reconciliation cycle of the operator configuration

Default: false
showStackTraces ✓ boolean Set quarkus.log.console.format to %d{yyyy-MM-dd HH:mm:ss,SSS} %-5p [%c{4.}] (%t) %s%e%n. See https://quarkus.io/guides/logging#logging-format

Default: false
useJvmImages ✓ boolean The operator will use JVM version of the images

Default: false
version ✓ string Set the operator version (used for testing)

SGConfig.spec.developer.patches

↩ Parent

Section to define patches for some StackGres Pods

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

adminui ✓ object Section to define volumes to be used by the adminui container
clusterController ✓ object Section to define volumes to be used by the cluster controller container
distributedlogsController ✓ object Section to define volumes to be used by the distributedlogs controller container
jobs ✓ object Section to define volumes to be used by the jobs container
operator ✓ object Section to define volumes to be used by the operator container
restapi ✓ object Section to define volumes to be used by the restapi container
SGConfig.spec.developer.patches.adminui

↩ Parent

Section to define volumes to be used by the adminui container

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

volumeMounts ✓ []object Pod’s container volume mounts. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volumemount-v1-core
volumes ✓ []object Pod volumes. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volume-v1-core
SGConfig.spec.developer.patches.clusterController

↩ Parent

Section to define volumes to be used by the cluster controller container

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

volumeMounts ✓ []object Pod’s container volume mounts. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volumemount-v1-core
volumes ✓ []object Pod volumes. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volume-v1-core
SGConfig.spec.developer.patches.distributedlogsController

↩ Parent

Section to define volumes to be used by the distributedlogs controller container

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

volumeMounts ✓ []object Pod’s container volume mounts. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volumemount-v1-core
volumes ✓ []object Pod volumes. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volume-v1-core
SGConfig.spec.developer.patches.jobs

↩ Parent

Section to define volumes to be used by the jobs container

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

volumeMounts ✓ []object Pod’s container volume mounts. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volumemount-v1-core
volumes ✓ []object Pod volumes. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volume-v1-core
SGConfig.spec.developer.patches.operator

↩ Parent

Section to define volumes to be used by the operator container

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

volumeMounts ✓ []object Pod’s container volume mounts. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volumemount-v1-core
volumes ✓ []object Pod volumes. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volume-v1-core
SGConfig.spec.developer.patches.restapi

↩ Parent

Section to define volumes to be used by the restapi container

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

volumeMounts ✓ []object Pod’s container volume mounts. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volumemount-v1-core
volumes ✓ []object Pod volumes. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#volume-v1-core

SGConfig.spec.extensions

↩ Parent

Section to configure extensions

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

cache ✓ object Section to configure extensions cache (experimental).

This feature is in beta and may cause failures, please use with caution and report any error to https://gitlab.com/ongresinc/stackgres/-/issues/new

repositoryUrls ✓ []string A list of extensions repository URLs used to retrieve extensions

To set a proxy for extensions repository add parameter proxyUrl to the URL: https://extensions.stackgres.io/postgres/repository?proxyUrl=<proxy scheme>%3A%2F%2F<proxy host>[%3A<proxy port>] (URL encoded)

Other URL parameters are:

  • skipHostnameVerification: set it to true in order to use a server or a proxy with a self signed certificate
  • retry: set it to <max retriex>[:<sleep before next retry>] in order to retry a request on failure
  • setHttpScheme: set it to true in order to force using HTTP scheme

    Default: [https://extensions.stackgres.io/postgres/repository]

SGConfig.spec.extensions.cache

↩ Parent

Section to configure extensions cache (experimental).

This feature is in beta and may cause failures, please use with caution and report any error to https://gitlab.com/ongresinc/stackgres/-/issues/new

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

enabled ✓ boolean When set to true enable the extensions cache.

This feature is in beta and may cause failures, please use with caution and report any error to https://gitlab.com/ongresinc/stackgres/-/issues/new

Default: false
hostPath ✓ string If set, will use a host path volume with the specified path for the extensions cache instead of a PersistentVolume
persistentVolume ✓ object Section to configure the extensions cache PersistentVolume
preloadedExtensions ✓ []string An array of extensions pattern used to pre-loaded estensions into the extensions cache

Default: [x86_64/linux/timescaledb-1.7.4-pg12]
SGConfig.spec.extensions.cache.persistentVolume

↩ Parent

Section to configure the extensions cache PersistentVolume

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

size ✓ string The PersistentVolume size for the extensions cache

Only use whole numbers (e.g. not 1e6) and K/Ki/M/Mi/G/Gi as units

Default: 1Gi
storageClass ✓ string If defined set storage class If set to “-” (equivalent to storageClass: "" in a PV spec) disables dynamic provisioning If undefined (the default) or set to null, no storageClass spec is set, choosing the default provisioner. (gp2 on AWS, standard on GKE, AWS & OpenStack)

SGConfig.spec.grafana

↩ Parent

Section to configure Grafana integration

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

autoEmbed ✓ boolean When set to true embed automatically Grafana into the Web Console by creating the StackGres dashboard and the read-only role used to read it from the Web Console

Default: false
dashboardConfigMap ✓ string The ConfigMap name with the dashboard JSON in the key grafana-dashboard.json that will be created in Grafana. If not set the default
dashboardId ✓ string The dashboard id that will be create in Grafana (see https://grafana.com/grafana/dashboards). By default 9628. (used to embed automatically Grafana)

Manual Steps:

Create grafana dashboard for postgres exporter and copy/paste share URL:

  • Grafana > Create > Import > Grafana.com Dashboard 9628 Copy/paste grafana dashboard URL for postgres exporter:
  • Grafana > Dashboard > Manage > Select postgres exporter dashboard > Copy URL
datasourceName ✓ string The datasource name used to create the StackGres Dashboard into Grafana

Default: Prometheus
password ✓ string The password to access Grafana. By default prom-operator (the default in for kube-prometheus-stack helm chart). (used to embed automatically Grafana)

Default: prom-operator
schema ✓ string The schema to access Grafana. By default http. (used to embed manually and automatically grafana)

Default: http
secretName ✓ string The name of secret with credentials to access Grafana. (used to embed automatically Grafana, alternative to use user and password)
secretNamespace ✓ string The namespace of secret with credentials to access Grafana. (used to embed automatically Grafana, alternative to use user and password)
secretPasswordKey ✓ string The key of secret with password used to access Grafana. (used to embed automatically Grafana, alternative to use user and password)
secretUserKey ✓ string The key of secret with username used to access Grafana. (used to embed automatically Grafana, alternative to use user and password)
token ✓ string The Grafana API token to access the PostgreSQL dashboard created in Grafana (used to embed manually Grafana)

Manual Steps:

Create and copy/paste grafana API token:

  • Grafana > Configuration > API Keys > Add API key (for viewer) > Copy key value
url ✓ string The URL of the PostgreSQL dashboard created in Grafana (used to embed manually Grafana)
user ✓ string The username to access Grafana. By default admin. (used to embed automatically Grafana)

Default: admin
webHost ✓ string The service host name to access grafana (used to embed manually and automatically Grafana). The parameter value should point to the grafana service following the DNS reference svc_name.namespace

SGConfig.spec.jobs

↩ Parent

Section to configure Operator Installation Jobs

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

affinity ✓ object Operator Installation Jobs affinity. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#affinity-v1-core
annotations ✓ object Operator Installation Jobs annotations
image ✓ object Section to configure Operator Installation Jobs image
nodeSelector ✓ object Operator Installation Jobs node selector
resources ✓ object Operator Installation Jobs resources. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#resourcerequirements-v1-core
serviceAccount ✓ object Section to configure Jobs ServiceAccount
tolerations ✓ []object Operator Installation Jobs tolerations. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#toleration-v1-core

SGConfig.spec.jobs.image

↩ Parent

Section to configure Operator Installation Jobs image

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

name ✓ string Operator Installation Jobs image name

Default: stackgres/jobs
pullPolicy ✓ string Operator Installation Jobs image pull policy

Default: IfNotPresent
tag ✓ string Operator Installation Jobs image tag

SGConfig.spec.jobs.serviceAccount

↩ Parent

Section to configure Jobs ServiceAccount

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

annotations ✓ object Jobs ServiceAccount annotations
repoCredentials ✓ []string Repositories credentials Secret names

SGConfig.spec.operator

↩ Parent

Section to configure Operator Pod

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

affinity ✓ object Operator Pod affinity. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#affinity-v1-core
annotations ✓ object Operator Pod annotations
image ✓ object Section to configure Operator image
nodeSelector ✓ object Operator Pod node selector
resources ✓ object Operator Pod resources. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#resourcerequirements-v1-core
service ✓ object Section to configure Operator Service
serviceAccount ✓ object Section to configure Operator ServiceAccount
tolerations ✓ []object Operator Pod tolerations. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#toleration-v1-core

SGConfig.spec.operator.image

↩ Parent

Section to configure Operator image

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

name ✓ string Operator image name

Default: stackgres/operator
pullPolicy ✓ string Operator image pull policy

Default: IfNotPresent
tag ✓ string Operator image tag

SGConfig.spec.operator.service

↩ Parent

Section to configure Operator Service

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

annotations ✓ object Section to configure Operator Service annotations

SGConfig.spec.operator.serviceAccount

↩ Parent

Section to configure Operator ServiceAccount

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

annotations ✓ object Section to configure Operator ServiceAccount annotations
repoCredentials ✓ []string Repositories credentials Secret names

SGConfig.spec.prometheus

↩ Parent

Section to configure Prometheus integration.

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

allowAutobind ✓ boolean If set to false disable automatic bind to Prometheus created using the Prometheus Operator. If disabled the cluster will not be binded to Prometheus automatically and will require manual intervention by the Kubernetes cluster administrator.

Default: true

SGConfig.spec.rbac

↩ Parent

Section to configure RBAC for Web Console admin user

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

create ✓ boolean When set to true the admin user is assigned the cluster-admin ClusterRole by creating ClusterRoleBinding.

Default: true

SGConfig.spec.restapi

↩ Parent

Section to configure REST API Pod

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

affinity ✓ object REST API Pod affinity. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#affinity-v1-core
annotations ✓ object REST API Pod annotations
image ✓ object Section to configure REST API image
name ✓ string REST API container name

Default: stackgres-restapi
nodeSelector ✓ object REST API Pod node selector
resources ✓ object REST API Pod resources. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#resourcerequirements-v1-core
service ✓ object Section to configure REST API Service
serviceAccount ✓ object Section to configure REST API ServiceAccount
tolerations ✓ []object REST API Pod tolerations. See https://kubernetes.io/docs/reference/generated/kubernetes-api/v1.28/#toleration-v1-core

SGConfig.spec.restapi.image

↩ Parent

Section to configure REST API image

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

name ✓ string REST API image name

Default: stackgres/restapi
pullPolicy ✓ string REST API image pull policy

Default: IfNotPresent
tag ✓ string REST API image tag

SGConfig.spec.restapi.service

↩ Parent

Section to configure REST API Service

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

annotations ✓ object REST API Service annotations

SGConfig.spec.restapi.serviceAccount

↩ Parent

Section to configure REST API ServiceAccount

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

annotations ✓ object REST API ServiceAccount annotations
repoCredentials ✓ []string Repositories credentials Secret names

SGConfig.spec.serviceAccount

↩ Parent

Section to configure Operator Installation ServiceAccount

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

annotations ✓ object Section to configure Installation ServiceAccount annotations
create ✓ boolean If true the Operator Installation ServiceAccount will be created

Default: true
repoCredentials ✓ []string Repositories credentials Secret names

SGConfig.spec.shardingSphere

↩ Parent

Section to configure integration with ShardingSphere operator

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

serviceAccount ✓ object Section to configure ServiceAccount used by ShardingSphere operator.

You may configure a specific value for a sharded cluster under section SGShardedCluster.speccoordinator.configurations.shardingSphere.serviceAccount.

SGConfig.spec.shardingSphere.serviceAccount

↩ Parent

Section to configure ServiceAccount used by ShardingSphere operator.

You may configure a specific value for a sharded cluster under section SGShardedCluster.speccoordinator.configurations.shardingSphere.serviceAccount.

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

name ✓ ✓ string The name of the ServiceAccount used by ShardingSphere operator
namespace ✓ ✓ string The namespace of the ServiceAccount used by ShardingSphere operator

SGConfig.status

↩ Parent

Status defines the observed state of SGConfig

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

conditions ✓ []object
grafana ✓ object
removeOldOperatorBundleResources ✓ boolean Indicate when the old operator bundle resources has been removed
version ✓ string Latest version of the operator used to check for updates

SGConfig.status.conditions[index]

↩ Parent

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

lastTransitionTime ✓ string Last time the condition transitioned from one status to another.
message ✓ string A human readable message indicating details about the transition.
reason ✓ string The reason for the condition’s last transition.
status ✓ string Status of the condition, one of True, False, Unknown.
type ✓ string Type of deployment condition.

SGConfig.status.grafana

↩ Parent

Property
Required
Updatable
May Require Restart
Type
 Description

Workaround for hugo bug not rendering first table row

configHash ✓ string Grafana configuration hash
token ✓ string Grafana Token that allow to access dashboards
urls ✓ []string Grafana URLs to StackGres dashboards