openserverless/templates/postgres.yaml

# Licensed to the Apache Software Foundation (ASF) under one
# or more contributor license agreements.  See the NOTICE file
# distributed with this work for additional information
# regarding copyright ownership.  The ASF licenses this file
# to you under the Apache License, Version 2.0 (the
# "License"); you may not use this file except in compliance
# with the License.  You may obtain a copy of the License at
#
#   http://www.apache.org/licenses/LICENSE-2.0
#
# Unless required by applicable law or agreed to in writing,
# software distributed under the License is distributed on an
# "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
# KIND, either express or implied.  See the License for the
# specific language governing permissions and limitations
# under the License.
#
---
apiVersion: kubegres.reactive-tech.io/v1
kind: Kubegres
metadata:
  name: openserverless-postgres
  namespace: openserverless
spec:
   replicas: {{replicas}}
   image: pgvector/pgvector:pg16
   database:
      size: {{size}}Gi
      storageClassName: {{storageClass}}
   customConfig: openserverless-postgres-conf
   failover:
    isDisabled: {{not failover}}
   scheduler:
      affinity:
      {% if affinity %}
        # prefer to not run on an invoker node (only prefer because of single node clusters)
        nodeAffinity:
          preferredDuringSchedulingIgnoredDuringExecution:
          - weight: 100
            preference:
              matchExpressions:
              - key: openserverless-role
                operator: NotIn
                values:
                - {{affinity_invoker_node_label}}
          - weight: 80
            preference:
              matchExpressions:
              - key: openserverless-role
                operator: In
                values:
                - {{affinity_core_node_label}}
      {% endif %}               
      tolerations:
      {% if tolerations %}   
        - key: "openserverless-role"
          operator: "Equal"
          value: {{toleration_role}}
          effect: "NoSchedule"
      {% endif %}   
   env:
      - name: POSTGRES_PASSWORD
        valueFrom:
           secretKeyRef:
              name: postgres-openserverless-secret
              key: superUserPassword
      - name: POSTGRES_REPLICATION_PASSWORD
        valueFrom:
           secretKeyRef:
              name: postgres-openserverless-secret
              key: replicationUserPassword
      - name: POSTGRES_OPENSERVERLESS_DB_PASSWORD
        valueFrom:
           secretKeyRef:
              name: postgres-openserverless-secret
              key: openserverlessUserPassword