Bucardo

Last updated: 2020-02-28

Table: bucardo.goat

Holds information on each table or sequence that may be replicated
Column Type Notes
id INTEGER NOT NULL DEFAULT nextval('goat_id_seq')
db TEXT NOT NULL
schemaname TEXT NOT NULL
tablename TEXT NOT NULL
reltype TEXT NOT NULL DEFAULT 'table'
pkey TEXT NULL
qpkey TEXT NULL
pkeytype TEXT NULL
has_delta BOOLEAN NOT NULL DEFAULT 'false'
ping BOOLEAN NULL
customselect TEXT NULL
source_makedelta ONOFF NOT NULL DEFAULT 'inherits'
target_makedelta ONOFF NOT NULL DEFAULT 'inherits'
rebuild_index SMALLINT NULL DEFAULT 0
ghost BOOLEAN NOT NULL DEFAULT 'false'
standard_conflict TEXT NULL
analyze_after_copy BOOLEAN NOT NULL DEFAULT 'true'
strict_checking BOOLEAN NOT NULL DEFAULT 'true'
delta_bypass BOOLEAN NOT NULL DEFAULT 'false'
delta_bypass_min BIGINT NULL
delta_bypass_count BIGINT NULL
delta_bypass_percent SMALLINT NULL
cdate TIMESTAMPTZ NOT NULL DEFAULT now()
Constraint Definition
goat_id_pk PRIMARY KEY (id)
goat_db_fk FOREIGN KEY (db) REFERENCES [bucardo.db](/Bucardo/schema/db)(name) ON UPDATE CASCADE ON DELETE RESTRICT
has_schemaname CHECK (length(schemaname) \> 1)
valid_reltype CHECK (reltype IN ('table','sequence'))
custom_needs_pkey CHECK ([customselect](/Bucardo/operations/customselect) IS NULL OR length(pkey) \> 1)
pkey_needs_type CHECK (pkey = '' OR pkeytype IS NOT NULL)
standard_conflict CHECK (((reltype \<\> 'table') OR (standard_conflict IS NULL)) OR (standard_conflict IN ('source','target','skip','random','latest','abort')))
standard_conflict_sequence CHECK (((reltype \<\> 'sequence') OR (standard_conflict IS NULL)) OR (standard_conflict IN ('source','target','skip','lowest','highest')))

Bucardo.org is hosted and supported by End Point Dev

End Point Dev logo

Need assistance with Bucardo?

End Point Dev offers professional support for Bucardo, as well as specializing in developing, designing, and marketing effective websites. Since 1995, our diverse team of developers has shown that End Point can handle your organization’s greatest web and database challenges.