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' |
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.