1apiVersion: sql.cnrm.cloud.google.com/v1beta1
2kind: SQLInstance
3metadata:
4 name: ${edge_sql_db_name}
5 namespace: edge-system
6 annotations:
7 cnrm.cloud.google.com/deletion-policy: abandon
8spec:
9 databaseVersion: POSTGRES_14
10 region: us-central1
11 rootPassword:
12 valueFrom:
13 secretKeyRef:
14 name: edge-sql-password
15 key: password
16 settings:
17 availabilityType: REGIONAL
18 backupConfiguration:
19 enabled: true
20 pointInTimeRecoveryEnabled: true
21 databaseFlags:
22 - name: cloudsql.enable_pg_cron
23 value: "on"
24 - name: cloudsql.iam_authentication
25 value: "on"
26 - name: cron.database_name
27 value: ${edge_sql_db_name}
28 - name: max_connections
29 value: "500"
30 deletionProtectionEnabled: true
31 tier: db-custom-8-53248
32---
33apiVersion: sql.cnrm.cloud.google.com/v1beta1
34kind: SQLDatabase
35metadata:
36 name: ${edge_sql_db_name}
37 namespace: edge-system
38 annotations:
39 cnrm.cloud.google.com/deletion-policy: abandon
40spec:
41 instanceRef:
42 name: ${edge_sql_db_name}
43---
44apiVersion: sql.cnrm.cloud.google.com/v1beta1
45kind: SQLInstance
46metadata:
47 name: ${edge_sql_db_name}-migrated
48 namespace: edge-system
49 annotations:
50 cnrm.cloud.google.com/deletion-policy: abandon
51 cnrm.cloud.google.com/state-into-spec: absent
52spec:
53 databaseVersion: POSTGRES_14
54 region: ${gcp_region}
55 rootPassword:
56 valueFrom:
57 secretKeyRef:
58 name: edge-sql-password
59 key: password
60 settings:
61 availabilityType: REGIONAL
62 backupConfiguration:
63 enabled: true
64 pointInTimeRecoveryEnabled: true
65 databaseFlags:
66 - name: cloudsql.enable_pg_cron
67 value: "on"
68 - name: cloudsql.iam_authentication
69 value: "on"
70 - name: cron.database_name
71 value: ${edge_sql_db_name}
72 - name: max_connections
73 value: "500"
74 deletionProtectionEnabled: true
75 tier: db-custom-8-53248
View as plain text