libpq conflict

[GaoLe996]

What happens?

I'm using the ducklake extension via pg_duckdb. When executing ATTACH 'ducklake:xxx', the following error occurs:

[XX000] ERROR: (PGDuckDB/pgduckdb_raw_query_cpp) IO Error: Failed to attach DuckLake MetaData "__ducklake_metadata_lake" at path + ""Unable to connect to Postgres at "": libpq is incorrectly linked to backend functions.

This seems to be caused by a libpq conflict. Could you please advise on how to resolve this issue?

To Reproduce

select duckdb.raw_query($$
INSTALL ducklake;
LOAD ducklake;
INSTALL httpfs;
LOAD httpfs;
INSTALL postgres;
LOAD postgres;
$$);

SELECT duckdb.raw_query($$
create secret ducklake_catalog_secret (
type postgres,
host 'xxx.xxx.xxx.xxx',
port 5432,
user xxx,
password 'xxxx',
database ducklake_catalog
);
$$);

SELECT duckdb.raw_query($$
CREATE SECRET rustfs_storage_secret (
type s3,
provider config,
endpoint 'xxx.xxx.xxx.xxx:9000',
key_id 'xxxxx',
secret 'xxxxx',
region 'us-east-1',
url_style 'path',
use_ssl false
);
$$);

select duckdb.raw_query($$
CREATE SECRET ducklake_secret (
type ducklake,
metadata_path '',
data_path 's3://ducklake/',
metadata_parameters map {'type': 'postgres', 'secret': 'ducklake_catalog_secret'}
);
$$);

select * from duckdb.query($$FROM duckdb_secrets()$$);

select duckdb.raw_query($$ATTACH 'ducklake:ducklake_secret' as lake;$$);

OS:

RockyLinux 9

pg_duckdb Version (if built from source use commit hash):

1.1.0

Postgres Version (if built from source use commit hash):

18

Hardware:

No response

Full Name:

vulgar cd

Affiliation:

Personal

What is the latest build you tested with? If possible, we recommend testing with the latest nightly build.

I have not tested with any build

Did you include all relevant data sets for reproducing the issue?

No - Other reason (please specify in the issue body)

Did you include all code required to reproduce the issue?

• Yes, I have

Did you include all relevant configuration (e.g., CPU architecture, Linux distribution) to reproduce the issue?

• Yes, I have