Publication v1 — postgresql.cnpg.io

apiVersion string

APIVersion defines the versioned schema of this representation of an object. Servers should convert recognized schemas to the latest internal value, and may reject unrecognized values. More info: https://git.k8s.io/community/contributors/devel/sig-architecture/api-conventions.md#resources

kind string

Kind is a string value representing the REST resource this object represents. Servers may infer this from the endpoint the client submits requests to. Cannot be updated. In CamelCase. More info: https://git.k8s.io/community/contributors/devel/sig-architecture/api-conventions.md#types-kinds

metadata object required

spec object required

PublicationSpec defines the desired state of Publication

cluster object required

The name of the PostgreSQL cluster that identifies the "publisher"

name string

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

dbname string required

The name of the database where the publication will be installed in the "publisher" cluster

name string required

The name of the publication inside PostgreSQL

parameters object

Publication parameters part of the `WITH` clause as expected by PostgreSQL `CREATE PUBLICATION` command

publicationReclaimPolicy string

The policy for end-of-life maintenance of this publication

enum: delete, retain

target object required

Target of the publication as expected by PostgreSQL `CREATE PUBLICATION` command

allTables boolean

Marks the publication as one that replicates changes for all tables in the database, including tables created in the future. Corresponding to `FOR ALL TABLES` in PostgreSQL.

objects []object

Just the following schema objects

maxItems: 100000

table object

Specifies a list of tables to add to the publication. Corresponding to `FOR TABLE` in PostgreSQL.

columns []string

The columns to publish

name string required

The table name

only boolean

Whether to limit to the table only or include all its descendants

schema string

The schema name

tablesInSchema string

Marks the publication as one that replicates changes for all tables in the specified list of schemas, including tables created in the future. Corresponding to `FOR TABLES IN SCHEMA` in PostgreSQL.

status object

PublicationStatus defines the observed state of Publication

applied boolean

Applied is true if the publication was reconciled correctly

message string

Message is the reconciliation output message

observedGeneration integer

A sequence number representing the latest desired state that was synchronized

format: int64