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