Bucardo

Last updated: 2020-02-28

Table: bucardo.db

Holds information about each database used in replication
Column Type Notes
name TEXT NOT NULL; this is the name Bucardo will use to refer to this database, not necessarily the database's actual name
dbhost TEXT NOT NULL DEFAULT ''
dbport TEXT NOT NULL DEFAULT 5432
dbname TEXT NOT NULL
dbuser TEXT NOT NULL
dbpass TEXT NULL
dbconn TEXT NOT NULL DEFAULT ''; contains connection parameters, such as "sslmode=require"
dbservice TEXT NULL
pgpass TEXT NULL
status TEXT NOT NULL DEFAULT 'active'
sourcelimit SMALLINT NOT NULL DEFAULT 0
targetlimit SMALLINT NOT NULL DEFAULT 0
server_side_prepares BOOLEAN NOT NULL DEFAULT 'true'
[makedelta](/Bucardo/operations/makedelta) ONOFF NOT NULL DEFAULT 'off'
cdate TIMESTAMPTZ NOT NULL DEFAULT now()
Constraint Definition
db_name_pk PRIMARY KEY (name)
db_status CHECK (status IN ('active','inactive'))
db_[makedelta](/Bucardo/operations/makedelta) CHECK ([makedelta](/Bucardo/operations/makedelta) \<\> 'inherit')
Index Unique? Definition
db_dsn_unique Yes (dbhost,dbport,dbname,dbuser) WHERE NOT name \~ '\^bctest'

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.