CREATE SECRET with PASSFILE: how to?

[ericemc3]

What happens?

Error on creating PG secret with a passfile

To Reproduce

CREATE SECRET (
    PASSFILE 'C:\...\.pgpass'
) ;

SQL Error: java.sql.SQLException: Binder Error: Unknown parameter 'passfile' for secret type 'postgres' with default provider 'config'

OS:

Win11

PostgreSQL Version:

16

DuckDB Version:

v1.3.0-dev3365

DuckDB Client:

jdbc

Full Name:

eric mauviere

Affiliation:

icem7

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

[ericemc3]

I still get an error message (though a different one)

FORCE INSTALL postgres FROM core_nightly;
LOAD postgres;

CREATE OR REPLACE SECRET (
    TYPE postgres,
    PASSFILE 'C:\...\.pgpass'
) ;

ATTACH '' AS postgres_db (TYPE postgres);

SQL Error: IO Error: Unable to connect to Postgres at passfile='C:\...\.pgpass' : connection to server at "localhost" (::1), port 5432 failed: fe_sendauth: no password supplied

with my pgpass written like this (and custom database, username & password):
localhost:5432:database:username:password