SlonyCollector
Collect slony metrics from postgresql
Dependencies
- psycopg2
Example Configuration
enabled = True
host = localhost
port = 5432
slony_node_string = Node [0-9] - [_a-z0-9]*@(.*).example.com
[instances]
[[database1]]
slony_db = postgres
slony_schema = _slony
[[database2]]
user = postgres
password = postgres
slony_db = data_db
slony_node_string = Node [0-9] - [_a-z0-9]*@(.*).i.example.com
slony_schema = _data_db
Options
Setting | Default | Description | Type |
---|---|---|---|
byte_unit | byte | Default numeric output(s) | str |
enabled | False | Enable collecting these metrics | bool |
host | localhost | Hostname | str |
instances | {} | Subcategory of slony instances that includes the slony database, and slony schema to be monitored. Optionally, user, password and slony_node_string maybe overridden per instance (see example). | dict |
measure_collector_time | False | Collect the collector run time in ms | bool |
metrics_blacklist | None | Regex to match metrics to block. Mutually exclusive with metrics_whitelist | NoneType |
metrics_whitelist | None | Regex to match metrics to transmit. Mutually exclusive with metrics_blacklist | NoneType |
password | postgres | Password | str |
port | 5432 | Port number | int |
slony_node_string | Node [0-9]+ - postgres@localhost | Regex for SQL SUBSTRING to extract the hostname from sl_node.no_comment | str |
user | postgres | Username | str |
Example Output
__EXAMPLESHERE__