load postgres_scanner error

[mdianjun]

What happens?

I have build with duckdb main branch or 1.4.2 branch, both have this error:

D load './build/release/extension/postgres_scanner/postgres_scanner.duckdb_extension';
Invalid Input Error: 
Failed to load './build/release/extension/postgres_scanner/postgres_scanner.duckdb_extension', The file is not a DuckDB extension. The metadata at the end of the file is invalid

To Reproduce

D load './build/release/extension/postgres_scanner/postgres_scanner.duckdb_extension';
Invalid Input Error: 
Failed to load './build/release/extension/postgres_scanner/postgres_scanner.duckdb_extension', The file is not a DuckDB extension. The metadata at the end of the file is invalid

OS:

DISTRIB_ID=Ubuntu DISTRIB_RELEASE=20.04 DISTRIB_CODENAME=focal DISTRIB_DESCRIPTION="Ubuntu 20.04.6 LTS"

PostgreSQL Version:

postgres-REL_15_13

DuckDB Version:

1.4.2

DuckDB Client:

No use

Full Name:

dianjun.ma

Affiliation:

openpie

Have you tried this on the latest main branch?

• I agree

Have you tried the steps to reproduce? Do they include all relevant data and configuration? Does the issue you report still appear there?

• I agree

[staticlibs]

@mdianjun

I believe this is a duplicate of #299, basically you need to either build the extension the same way it is built on CI (with VCPKG etc) or to append the extension metadata manually (with CMake or Python script) - see details in the linked issue in #299.

Closing as a duplicate, please comment if it needs to be reopened.