Bucardo/tables/bucardo.db
From Bucardo
Table: bucardo.db
| 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 | 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 | CHECK (makedelta <> 'inherit') |
| Index | Unique? | Definition |
|---|---|---|
| db_dsn_unique | Yes | (dbhost,dbport,dbname,dbuser) WHERE NOT name ~ '^bctest' |
