Update

With eranger-stablenet-fdw 8.1.3 we changed the type of the id field within the foreign tables from BIGINT to TEXT. This was needed to avoid ID clashes on multi server view systems. If the configured StableNet APIs contain a server ID suffix, the ID now has the form <id>@<server_id> (e.g. 47654@customer). Usually this should not have a big impact on existing data queries, but under some circumstances refactorings might be needed.

As usual, dont forget to execute /opt/stablenet-fdw/init-foreign-tables.sh -h <host> -p <port> -d <database> -U <user> -o <owner> after the update.

Updating from a version <= 8.1.2 to 8.1.3, a switch from the old measurement data sync to the new one is needed (Aggregated Measurement Data ).

Update Package

sudo dnf update eranger-stablenet-fdw

Updating Foreign Tables

/opt/stablenet-fdw/init-foreign-tables.sh -h <host> -p <port> -d <database> -U <user> -o <owner>

e.g.

/opt/stablenet-fdw/init-foreign-tables.sh -U postgres -h localhost -p 5432 -d infosim -o infosim