FDW Wrappers error: 'component verification failed'

If you are observing an ERROR: HV000: guest fdw error: component verification failed when querying a wrapper foreign tables, it indicates that the configured Wasm package metadata does not match the downloaded component. As a security measure, the Wrappers extension blocks the module when this mismatch occurs.

To resolve this, update your foreign server configuration to use the correct package version and checksum. Details depend on the exact Wrapper and can be found here: https://fdw.dev/catalog/wasm/

How to fix the configuration: Run the following SQL via the SQL Editor:

1
ALTER SERVER example_server OPTIONS (
2
  SET fdw_package_url '[THE_CORRECT_URL]',
3
  SET fdw_package_version '[THE_CORRECT_VERSION]',
4
  SET fdw_package_checksum '[INTERNAL_ID]'
5
);

Verify the update: You can confirm the update by inspecting the server options:

1
select srvname, unnest(srvoptions) as option
2
from pg_foreign_server
3
where srvname = 'example_server';

Test the connection by querying your foreign table:

1
select * from example_table limit 1;