apiVersion: sql.cnrm.cloud.google.com/v1beta1
kind: SQLInstance
metadata:
  name: ${edge_sql_db_name}
  namespace: edge-system
  annotations:
    cnrm.cloud.google.com/deletion-policy: abandon
spec:
  databaseVersion: POSTGRES_14
  region: us-central1
  rootPassword:
    valueFrom:
      secretKeyRef:
        name: edge-sql-password
        key: password
  settings:
    availabilityType: REGIONAL
    backupConfiguration:
      enabled: true
      pointInTimeRecoveryEnabled: true
    databaseFlags:
    - name: cloudsql.enable_pg_cron
      value: "on"
    - name: cloudsql.iam_authentication
      value: "on"
    - name: cron.database_name
      value: ${edge_sql_db_name}
    - name: max_connections
      value: "500"
    deletionProtectionEnabled: true
    tier: db-custom-8-53248
---
apiVersion: sql.cnrm.cloud.google.com/v1beta1
kind: SQLDatabase
metadata:
  name: ${edge_sql_db_name}
  namespace: edge-system
  annotations:
    cnrm.cloud.google.com/deletion-policy: abandon
spec:
  instanceRef:
    name: ${edge_sql_db_name}
---
apiVersion: sql.cnrm.cloud.google.com/v1beta1
kind: SQLInstance
metadata:
  name: ${edge_sql_db_name}-migrated
  namespace: edge-system
  annotations:
    cnrm.cloud.google.com/deletion-policy: abandon
    cnrm.cloud.google.com/state-into-spec: absent
spec:
  databaseVersion: POSTGRES_14
  region: ${gcp_region}
  rootPassword:
    valueFrom:
      secretKeyRef:
        name: edge-sql-password
        key: password
  settings:
    availabilityType: REGIONAL
    backupConfiguration:
      enabled: true
      pointInTimeRecoveryEnabled: true
    databaseFlags:
    - name: cloudsql.enable_pg_cron
      value: "on"
    - name: cloudsql.iam_authentication
      value: "on"
    - name: cron.database_name
      value: ${edge_sql_db_name}
    - name: max_connections
      value: "500"
    deletionProtectionEnabled: true
    tier: db-custom-8-53248