cnpg 0.1.0

Kubernetes CRD bindings for CloudNativePG
Documentation
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
use crate::prelude::*;

// WARNING: generated by kopium - manual changes will be overwritten
// kopium command: kopium -f /home/mmoreiradj/git/crd-rs/crds/cnpg/postgresql.cnpg.io_databases.yaml --schema=derived -d --hide-prelude
// kopium version: 0.22.5

/// Specification of the desired Database.
/// More info: <https://git.k8s.io/community/contributors/devel/sig-architecture/api-conventions.md#spec-and-status>
#[derive(CustomResource, Serialize, Deserialize, Clone, Debug, JsonSchema)]
#[kube(
    group = "postgresql.cnpg.io",
    version = "v1",
    kind = "Database",
    plural = "databases"
)]
#[kube(namespaced)]
#[kube(status = "DatabaseStatus")]
pub struct DatabaseSpec {
    /// Maps to the `ALLOW_CONNECTIONS` parameter of `CREATE DATABASE` and
    /// `ALTER DATABASE`. If false then no one can connect to this database.
    #[serde(
        default,
        skip_serializing_if = "Option::is_none",
        rename = "allowConnections"
    )]
    pub allow_connections: Option<bool>,
    /// Maps to the `BUILTIN_LOCALE` parameter of `CREATE DATABASE`. This
    /// setting cannot be changed. Specifies the locale name when the
    /// builtin provider is used. This option requires `localeProvider` to
    /// be set to `builtin`. Available from PostgreSQL 17.
    #[serde(
        default,
        skip_serializing_if = "Option::is_none",
        rename = "builtinLocale"
    )]
    pub builtin_locale: Option<String>,
    /// The name of the PostgreSQL cluster hosting the database.
    pub cluster: DatabaseCluster,
    /// Maps to the `COLLATION_VERSION` parameter of `CREATE DATABASE`. This
    /// setting cannot be changed.
    #[serde(
        default,
        skip_serializing_if = "Option::is_none",
        rename = "collationVersion"
    )]
    pub collation_version: Option<String>,
    /// Maps to the `CONNECTION LIMIT` clause of `CREATE DATABASE` and
    /// `ALTER DATABASE`. How many concurrent connections can be made to
    /// this database. -1 (the default) means no limit.
    #[serde(
        default,
        skip_serializing_if = "Option::is_none",
        rename = "connectionLimit"
    )]
    pub connection_limit: Option<i64>,
    /// The policy for end-of-life maintenance of this database.
    #[serde(
        default,
        skip_serializing_if = "Option::is_none",
        rename = "databaseReclaimPolicy"
    )]
    pub database_reclaim_policy: Option<DatabaseDatabaseReclaimPolicy>,
    /// Maps to the `ENCODING` parameter of `CREATE DATABASE`. This setting
    /// cannot be changed. Character set encoding to use in the database.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub encoding: Option<String>,
    /// Ensure the PostgreSQL database is `present` or `absent` - defaults to "present".
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub ensure: Option<DatabaseEnsure>,
    /// The list of extensions to be managed in the database
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub extensions: Option<Vec<DatabaseExtensions>>,
    /// The list of foreign data wrappers to be managed in the database
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub fdws: Option<Vec<DatabaseFdws>>,
    /// Maps to the `ICU_LOCALE` parameter of `CREATE DATABASE`. This
    /// setting cannot be changed. Specifies the ICU locale when the ICU
    /// provider is used. This option requires `localeProvider` to be set to
    /// `icu`. Available from PostgreSQL 15.
    #[serde(default, skip_serializing_if = "Option::is_none", rename = "icuLocale")]
    pub icu_locale: Option<String>,
    /// Maps to the `ICU_RULES` parameter of `CREATE DATABASE`. This setting
    /// cannot be changed. Specifies additional collation rules to customize
    /// the behavior of the default collation. This option requires
    /// `localeProvider` to be set to `icu`. Available from PostgreSQL 16.
    #[serde(default, skip_serializing_if = "Option::is_none", rename = "icuRules")]
    pub icu_rules: Option<String>,
    /// Maps to the `IS_TEMPLATE` parameter of `CREATE DATABASE` and `ALTER
    /// DATABASE`. If true, this database is considered a template and can
    /// be cloned by any user with `CREATEDB` privileges.
    #[serde(
        default,
        skip_serializing_if = "Option::is_none",
        rename = "isTemplate"
    )]
    pub is_template: Option<bool>,
    /// Maps to the `LOCALE` parameter of `CREATE DATABASE`. This setting
    /// cannot be changed. Sets the default collation order and character
    /// classification in the new database.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub locale: Option<String>,
    /// Maps to the `LC_CTYPE` parameter of `CREATE DATABASE`. This setting
    /// cannot be changed.
    #[serde(
        default,
        skip_serializing_if = "Option::is_none",
        rename = "localeCType"
    )]
    pub locale_c_type: Option<String>,
    /// Maps to the `LC_COLLATE` parameter of `CREATE DATABASE`. This
    /// setting cannot be changed.
    #[serde(
        default,
        skip_serializing_if = "Option::is_none",
        rename = "localeCollate"
    )]
    pub locale_collate: Option<String>,
    /// Maps to the `LOCALE_PROVIDER` parameter of `CREATE DATABASE`. This
    /// setting cannot be changed. This option sets the locale provider for
    /// databases created in the new cluster. Available from PostgreSQL 16.
    #[serde(
        default,
        skip_serializing_if = "Option::is_none",
        rename = "localeProvider"
    )]
    pub locale_provider: Option<String>,
    /// The name of the database to create inside PostgreSQL. This setting cannot be changed.
    pub name: String,
    /// Maps to the `OWNER` parameter of `CREATE DATABASE`.
    /// Maps to the `OWNER TO` command of `ALTER DATABASE`.
    /// The role name of the user who owns the database inside PostgreSQL.
    pub owner: String,
    /// The list of schemas to be managed in the database
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub schemas: Option<Vec<DatabaseSchemas>>,
    /// The list of foreign servers to be managed in the database
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub servers: Option<Vec<DatabaseServers>>,
    /// Maps to the `TABLESPACE` parameter of `CREATE DATABASE`.
    /// Maps to the `SET TABLESPACE` command of `ALTER DATABASE`.
    /// The name of the tablespace (in PostgreSQL) that will be associated
    /// with the new database. This tablespace will be the default
    /// tablespace used for objects created in this database.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub tablespace: Option<String>,
    /// Maps to the `TEMPLATE` parameter of `CREATE DATABASE`. This setting
    /// cannot be changed. The name of the template from which to create
    /// this database.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub template: Option<String>,
}

/// The name of the PostgreSQL cluster hosting the database.
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseCluster {
    /// Name of the referent.
    /// This field is effectively required, but due to backwards compatibility is
    /// allowed to be empty. Instances of this type with an empty value here are
    /// almost certainly wrong.
    /// More info: <https://kubernetes.io/docs/concepts/overview/working-with-objects/names/#names>
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub name: Option<String>,
}

/// Specification of the desired Database.
/// More info: <https://git.k8s.io/community/contributors/devel/sig-architecture/api-conventions.md#spec-and-status>
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub enum DatabaseDatabaseReclaimPolicy {
    #[serde(rename = "delete")]
    Delete,
    #[serde(rename = "retain")]
    Retain,
}

/// Specification of the desired Database.
/// More info: <https://git.k8s.io/community/contributors/devel/sig-architecture/api-conventions.md#spec-and-status>
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub enum DatabaseEnsure {
    #[serde(rename = "present")]
    Present,
    #[serde(rename = "absent")]
    Absent,
}

/// ExtensionSpec configures an extension in a database
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseExtensions {
    /// Specifies whether an object (e.g schema) should be present or absent
    /// in the database. If set to `present`, the object will be created if
    /// it does not exist. If set to `absent`, the extension/schema will be
    /// removed if it exists.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub ensure: Option<DatabaseExtensionsEnsure>,
    /// Name of the object (extension, schema, FDW, server)
    pub name: String,
    /// The name of the schema in which to install the extension's objects,
    /// in case the extension allows its contents to be relocated. If not
    /// specified (default), and the extension's control file does not
    /// specify a schema either, the current default object creation schema
    /// is used.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub schema: Option<String>,
    /// The version of the extension to install. If empty, the operator will
    /// install the default version (whatever is specified in the
    /// extension's control file)
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub version: Option<String>,
}

/// ExtensionSpec configures an extension in a database
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub enum DatabaseExtensionsEnsure {
    #[serde(rename = "present")]
    Present,
    #[serde(rename = "absent")]
    Absent,
}

/// FDWSpec configures an Foreign Data Wrapper in a database
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseFdws {
    /// Specifies whether an object (e.g schema) should be present or absent
    /// in the database. If set to `present`, the object will be created if
    /// it does not exist. If set to `absent`, the extension/schema will be
    /// removed if it exists.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub ensure: Option<DatabaseFdwsEnsure>,
    /// Name of the handler function (e.g., "postgres_fdw_handler").
    /// This will be empty if no handler is specified. In that case,
    /// the default handler is registered when the FDW extension is created.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub handler: Option<String>,
    /// Name of the object (extension, schema, FDW, server)
    pub name: String,
    /// Options specifies the configuration options for the FDW.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub options: Option<Vec<DatabaseFdwsOptions>>,
    /// Owner specifies the database role that will own the Foreign Data Wrapper.
    /// The role must have superuser privileges in the target database.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub owner: Option<String>,
    /// List of roles for which `USAGE` privileges on the FDW are granted or revoked.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub usage: Option<Vec<DatabaseFdwsUsage>>,
    /// Name of the validator function (e.g., "postgres_fdw_validator").
    /// This will be empty if no validator is specified. In that case,
    /// the default validator is registered when the FDW extension is created.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub validator: Option<String>,
}

/// FDWSpec configures an Foreign Data Wrapper in a database
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub enum DatabaseFdwsEnsure {
    #[serde(rename = "present")]
    Present,
    #[serde(rename = "absent")]
    Absent,
}

/// OptionSpec holds the name, value and the ensure field for an option
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseFdwsOptions {
    /// Specifies whether an option should be present or absent in
    /// the database. If set to `present`, the option will be
    /// created if it does not exist. If set to `absent`, the
    /// option will be removed if it exists.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub ensure: Option<DatabaseFdwsOptionsEnsure>,
    /// Name of the option
    pub name: String,
    /// Value of the option
    pub value: String,
}

/// OptionSpec holds the name, value and the ensure field for an option
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub enum DatabaseFdwsOptionsEnsure {
    #[serde(rename = "present")]
    Present,
    #[serde(rename = "absent")]
    Absent,
}

/// UsageSpec configures a usage for a foreign data wrapper
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseFdwsUsage {
    /// Name of the usage
    pub name: String,
    /// The type of usage
    #[serde(default, skip_serializing_if = "Option::is_none", rename = "type")]
    pub r#type: Option<DatabaseFdwsUsageType>,
}

/// UsageSpec configures a usage for a foreign data wrapper
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub enum DatabaseFdwsUsageType {
    #[serde(rename = "grant")]
    Grant,
    #[serde(rename = "revoke")]
    Revoke,
}

/// SchemaSpec configures a schema in a database
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseSchemas {
    /// Specifies whether an object (e.g schema) should be present or absent
    /// in the database. If set to `present`, the object will be created if
    /// it does not exist. If set to `absent`, the extension/schema will be
    /// removed if it exists.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub ensure: Option<DatabaseSchemasEnsure>,
    /// Name of the object (extension, schema, FDW, server)
    pub name: String,
    /// The role name of the user who owns the schema inside PostgreSQL.
    /// It maps to the `AUTHORIZATION` parameter of `CREATE SCHEMA` and the
    /// `OWNER TO` command of `ALTER SCHEMA`.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub owner: Option<String>,
}

/// SchemaSpec configures a schema in a database
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub enum DatabaseSchemasEnsure {
    #[serde(rename = "present")]
    Present,
    #[serde(rename = "absent")]
    Absent,
}

/// ServerSpec configures a server of a foreign data wrapper
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseServers {
    /// Specifies whether an object (e.g schema) should be present or absent
    /// in the database. If set to `present`, the object will be created if
    /// it does not exist. If set to `absent`, the extension/schema will be
    /// removed if it exists.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub ensure: Option<DatabaseServersEnsure>,
    /// The name of the Foreign Data Wrapper (FDW)
    pub fdw: String,
    /// Name of the object (extension, schema, FDW, server)
    pub name: String,
    /// Options specifies the configuration options for the server
    /// (key is the option name, value is the option value).
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub options: Option<Vec<DatabaseServersOptions>>,
    /// List of roles for which `USAGE` privileges on the server are granted or revoked.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub usage: Option<Vec<DatabaseServersUsage>>,
}

/// ServerSpec configures a server of a foreign data wrapper
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub enum DatabaseServersEnsure {
    #[serde(rename = "present")]
    Present,
    #[serde(rename = "absent")]
    Absent,
}

/// OptionSpec holds the name, value and the ensure field for an option
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseServersOptions {
    /// Specifies whether an option should be present or absent in
    /// the database. If set to `present`, the option will be
    /// created if it does not exist. If set to `absent`, the
    /// option will be removed if it exists.
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub ensure: Option<DatabaseServersOptionsEnsure>,
    /// Name of the option
    pub name: String,
    /// Value of the option
    pub value: String,
}

/// OptionSpec holds the name, value and the ensure field for an option
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub enum DatabaseServersOptionsEnsure {
    #[serde(rename = "present")]
    Present,
    #[serde(rename = "absent")]
    Absent,
}

/// UsageSpec configures a usage for a foreign data wrapper
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseServersUsage {
    /// Name of the usage
    pub name: String,
    /// The type of usage
    #[serde(default, skip_serializing_if = "Option::is_none", rename = "type")]
    pub r#type: Option<DatabaseServersUsageType>,
}

/// UsageSpec configures a usage for a foreign data wrapper
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub enum DatabaseServersUsageType {
    #[serde(rename = "grant")]
    Grant,
    #[serde(rename = "revoke")]
    Revoke,
}

/// Most recently observed status of the Database. This data may not be up to
/// date. Populated by the system. Read-only.
/// More info: <https://git.k8s.io/community/contributors/devel/sig-architecture/api-conventions.md#spec-and-status>
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseStatus {
    /// Applied is true if the database was reconciled correctly
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub applied: Option<bool>,
    /// Extensions is the status of the managed extensions
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub extensions: Option<Vec<DatabaseStatusExtensions>>,
    /// FDWs is the status of the managed FDWs
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub fdws: Option<Vec<DatabaseStatusFdws>>,
    /// Message is the reconciliation output message
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub message: Option<String>,
    /// A sequence number representing the latest
    /// desired state that was synchronized
    #[serde(
        default,
        skip_serializing_if = "Option::is_none",
        rename = "observedGeneration"
    )]
    pub observed_generation: Option<i64>,
    /// Schemas is the status of the managed schemas
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub schemas: Option<Vec<DatabaseStatusSchemas>>,
    /// Servers is the status of the managed servers
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub servers: Option<Vec<DatabaseStatusServers>>,
}

/// DatabaseObjectStatus is the status of the managed database objects
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseStatusExtensions {
    /// True of the object has been installed successfully in
    /// the database
    pub applied: bool,
    /// Message is the object reconciliation message
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub message: Option<String>,
    /// The name of the object
    pub name: String,
}

/// DatabaseObjectStatus is the status of the managed database objects
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseStatusFdws {
    /// True of the object has been installed successfully in
    /// the database
    pub applied: bool,
    /// Message is the object reconciliation message
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub message: Option<String>,
    /// The name of the object
    pub name: String,
}

/// DatabaseObjectStatus is the status of the managed database objects
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseStatusSchemas {
    /// True of the object has been installed successfully in
    /// the database
    pub applied: bool,
    /// Message is the object reconciliation message
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub message: Option<String>,
    /// The name of the object
    pub name: String,
}

/// DatabaseObjectStatus is the status of the managed database objects
#[derive(Serialize, Deserialize, Clone, Debug, JsonSchema)]
pub struct DatabaseStatusServers {
    /// True of the object has been installed successfully in
    /// the database
    pub applied: bool,
    /// Message is the object reconciliation message
    #[serde(default, skip_serializing_if = "Option::is_none")]
    pub message: Option<String>,
    /// The name of the object
    pub name: String,
}