Bucardo/tables/bucardo.db connlog

From Bucardo

Jump to: navigation, search

Table: bucardo.db_connlog

Tracks connection attempts to each database when its information changes
ColumnTypeNotes
db TEXT NOT NULL
conndate TIMESTAMPTZ NOT NULL DEFAULT now()
connstring TEXT NOT NULL
status TEXT NOT NULL DEFAULT 'unknown'
version TEXT NULL
ConstraintDefinition
db_connlog_dbid_fkFOREIGN KEY (db) REFERENCES bucardo.db(name) ON UPDATE CASCADE ON DELETE CASCADE
db_connlog_statusCHECK (status IN ('unknown', 'good', 'down', 'unreachable'))
Personal tools