9.0.0

Switch to PostgreSQL 17 dependencies.

8.1.9

Makes getting taggables, measurements, open alarms, monitors and links paged.
Syncs data for external measurements
Adds stablenet_magellan_organisation foreign table

8.1.8

Always executes VACUUM (ANALYZE) after doing measurement data sync.

8.1.7

Gets rid of stats_agg_max and percentile_agg_max in aggregate tables because for new data those are just duplicates of stats_agg and percentile_agg. Adds value_min and value_max instead.

8.1.6

Installs or updates timescaledb, timescaledb_toolkit and tablefunc extensions in init-foreign-tables.sh

8.1.5

Add more robust retry behavior.

8.1.4

Allows to disable measurement data sync for individual tables.
Fixes swapped avg and min when getting data from StableNet tables.
Caps buckets for percentile_agg stats to 60 and sets max error to 0.05 (5%)
Improves performance of measurment data sync.
Adjusts FDW and Measurement data sync to a breaking change in StableNet. Metric keys changed from a format like SNMP_1234 to #1234. This means that the aggregated data in measurement history can't be used anymore and that a complete resync is needed. The best way to achieve this is to manually delete the aggregated tables and to the sync preparation according to documentation (https://docs.skoor.com/skoor-doc/aggregated-measurement-data).
Allows to specify the history sync range using history_start_date and history_end_date

8.1.3

Improves incremental data sync performance.
Adds server_id to foreign tables.
Ensures that measurement_ids are always unique on multi server views by changing the type of the measurment_id to TEXT and adding a suffix to the ID if a server_id is set (e.g. 1234@server1)
Adds stablenet_taggable_monitor foreign table.

8.1.2

Implements DB based history data sync

8.1.1

Make endTime of measurement endpoint optional.

8.1.0

No changes

8.0.4

Improves calculation of permission hash.

8.0.3

Uses pages calls to /measurements endpoint to avoid OutOfMemoryException on the StableNet REST API
Implements stablenet_monitor table.
Supports more qualifier operators like IN, >, <, ...
Implements stablenet_taggable_tag and other taggable_..._tag tables.
Fixes bug that that breaks open_alarm table in case no tags are given.

8.0.2

Implements better StableNet REST API error handling.
Explicitly set the HTTP header "Accept: application/json` in requests to the StableNet API as the new default seems to be CSV for some endpoints.

8.0.1

Accepts gzipped response when getting data from StableNet backend.

8.0.0

No changes

7.3.18

Implements stablenet_open_alarm table

7.3.17

Fallback to categories field on /meaurements endpoint. This field has been renamed from categories to tags in SP3, but we also want to run on SP3 for the time being.

7.3.16

Makes the stablenet_measurement_metric table using the /measurement-data/<obid>/metrics StableNet REST API endpoint instead of the missing (since 24 SP4) /measurements/{measurementId}/metrics one.

7.3.15

Implements geo and link endpoints
Fixes bug that causes an error when getting ping measurements.

7.3.14

Makes aggregated measurement data retention configurable using the -r flag.

7.3.13

Returns better estimates for number of rows. This helps the query planner to choose better query plans.

7.3.12

Fixes bug that breaks some calls to stablenet_measurement, stablenet_measurement_metricand stablenet_measurement_data in multi server environments.

7.3.11

Adds stablenet_multi_server_view table to get configured servers.
Adds stablenet_permission_hash to get a hash for the accessible measurements. This hash is used by the SKOOR Webservice to optimize caching.

7.3.10

Fixes timestamp of stablenet_measurement_data when getting data in a different interval than the requested bucket_size.

7.3.9

Adds interval column to stablenet_measurement_data and stablenet_measurement_data_aggregated.
Ensures that compression policy on stablenet_measurement_data_aggregated is setup after data has been fully initialized.

7.3.8

Adds additional compound indexes without server_name columns to stablenet_measurement_data_aggregated to increase performance when performing queries without server_name in where or on clause.

7.3.7

Adds TimescaleDB Toolkit

7.3.6

Adds additional log output for stablenet_measurement_data.
Increase connect time to StableNet API to 20 seconds.

7.3.5

Implements workaround to mitigate StableNet API /measurement-data bug that causes some missing metrics when mixing metric types.

7.3.4

Fixes stablenet_measurement_data for single measurement

7.3.3

Renames stablenet_<domain> tables to stablenet_taggable_<domain> to make it more obvious that those are in fact derived from stablenet_taggable with a preconfigured domain.

7.3.2

Ensures that stablenet_measurement_data return all received rows.
Implements tag_filter for stablenet_taggable, stablenet_<domain>, stablenet_measurement and stablenet_measurement_data.

7.3.1

Adds a timeout of 10 minutes to StableNet API HTTP requests.

7.3.0

Initial version

SKOOR REST FDW Changelog

9.0.0

8.1.2

8.1.1

8.1.0

8.0.1

8.0.0