1.9. Table: sl_path

Holds connection information for the paths between nodes, and the synchronisation delay

Structure of sl_path

pa_server

integer PRIMARY KEY REFERENCES sl_node>

The Node ID # (from sl_node.no_id) of the data source

pa_client

integer PRIMARY KEY REFERENCES sl_node>

The Node ID # (from sl_node.no_id) of the data target

pa_conninfo

text NOT NULL

The PostgreSQL connection string used to connect to the source node.

pa_connretry

integer

The synchronisation delay, in seconds

Tables referencing sl_listen via Foreign Key Constraints