Column | Type | Notes |
---|---|---|
name | TEXT | NOT NULL UNIQUE |
source | TEXT | NOT NULL |
targetdb | TEXT | NULL |
targetgroup | TEXT | NULL |
synctype | TEXT | NOT NULL |
stayalive | BOOLEAN | NOT NULL DEFAULT 'true' |
kidsalive | BOOLEAN | NOT NULL DEFAULT 'true' |
use[customselect](/Bucardo/operations/customselect) | BOOLEAN | NOT NULL DEFAULT 'false' |
copytype | TEXT | NOT NULL DEFAULT 'copy' |
copyextra | TEXT | NOT NULL DEFAULT '' |
deletemethod | TEXT | NOT NULL DEFAULT 'delete' |
limitdbs | SMALLINT | NOT NULL DEFAULT 0 |
ping | BOOLEAN | NOT NULL DEFAULT true |
do_listen | BOOLEAN | NOT NULL DEFAULT false |
checktime | INTERVAL | NULL |
status | TEXT | NOT NULL DEFAULT 'active' |
source_makedelta | ONOFF | NOT NULL DEFAULT 'inherits' |
target_makedelta | ONOFF | NOT NULL DEFAULT 'inherits' |
rebuild_index | SMALLINT | NOT NULL DEFAULT 0 |
priority | SMALLINT | NOT NULL DEFAULT 0 |
txnmode | TEXT | NOT NULL DEFAULT 'SERIALIZABLE' |
analyze_after_copy | BOOLEAN | NOT NULL DEFAULT 'true' |
strict_checking | BOOLEAN | NOT NULL DEFAULT 'true' |
overdue | INTERVAL | NOT NULL DEFAULT '0 seconds'::interval |
expired | INTERVAL | NOT NULL DEFAULT '0 seconds'::interval |
track_rates | BOOLEAN | NOT NULL DEFAULT 'false' |
onetimecopy | SMALLINT | NOT NULL DEFAULT 0 |
lifetime | INTERVAL | NULL |
maxkicks | INTEGER | NOT NULL DEFAULT 0 |
cdate | TIMESTAMPTZ | NOT NULL DEFAULT now() |
Constraint | Definition |
---|---|
sync_name_pk | PRIMARY KEY (name) |
sync_source_herd_fk | FOREIGN KEY (source) REFERENCES [bucardo.herd](/Bucardo/schema/herd)(name) ON UPDATE CASCADE ON DELETE RESTRICT |
sync_targetdb_fk | FOREIGN KEY ([targetdb](/Bucardo/object_types/targetdb)) REFERENCES [bucardo.db](/Bucardo/schema/db)(name) ON UPDATE CASCADE ON DELETE RESTRICT |
sync_targetgroup_fk | FOREIGN KEY ([targetgroup](/Bucardo/object_types/targetgroup)) REFERENCES [bucardo.dbgroup](/Bucardo/schema/dbgroup)(name) ON UPDATE CASCADE ON DELETE RESTRICT |
sync_type | CHECK (synctype IN ('[pushdelta](/Bucardo/object_types/pushdelta)','[fullcopy](/Bucardo/object_types/fullcopy)','[swap](/Bucardo/object_types/swap)')) |
sync_copytype | CHECK (copytype IN ('insert','copy')) |
sync_deletemethod | CHECK (deletemethod IN ('truncate', 'delete', 'truncate_cascade')) |
sync_validtarget | CHECK ((([targetdb](/Bucardo/object_types/targetdb) IS NULL) AND ([targetgroup](/Bucardo/object_types/targetgroup) IS NOT NULL)) OR (([targetdb](/Bucardo/object_types/targetdb) IS NOT NULL) AND ([targetgroup](/Bucardo/object_types/targetgroup) IS NULL))) |
sync_swap_nogroup | CHECK (synctype \<\> '[swap](/Bucardo/object_types/swap)' OR [targetdb](/Bucardo/object_types/targetdb) IS NOT NULL) |
Index | Unique? | Definition |
---|---|---|
sync_source_targetdb_type | Yes | (source, [targetdb](/Bucardo/object_types/targetdb), synctype) |
sync_source_targetgroup_type | Yes | (source, [targetgroup](/Bucardo/object_types/targetgroup), synctype) |
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.