Error when connecting to Aurora

[pquadri]

What happens?

After Mytherin@c37606d connecting to an Aurora results in
ERROR: Function pg_stat_get_wal_receiver() is currently not supported in Aurora

Can we make that bit optional?

To Reproduce

try to run a postgres_scan from aurora, i have issues with postgres_attach as well but that might be on my connection.
does not happen with the same query on duckdb 0.9.0 (which i assume is old enough to not have that line)

OS:

mac os x

PostgreSQL Version:

14

DuckDB Version:

9.2.0

DuckDB Client:

Python

Full Name:

Paolo Quadri

Affiliation:

Remote.com

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

[Mytherin]

Thanks for the report! Should be fixed in #131

[faridgt]

I built duckdb 0.9.2 and with postgres extension but still get this error

ERROR: Function pg_stat_get_wal_receiver() is currently not supported in Aurora

I double checked the changed mention in the fix and they are found on build code

any idea?

[Mytherin]

You are most likely still using the old version of the extension, try installing the nightly:

force install postgres_scanner from 'http://nightly-extensions.duckdb.org';

[faridgt]

You are most likely still using the old version of the extension, try installing the nightly:

force install postgres_scanner from 'http://nightly-extensions.duckdb.org';

thanks @Mytherin , it worked by calling:
force install postgres;

in dbt by using
{{ config(materialized='table', pre_hook="force install postgres;" ) }}