Attaching DB with sslmode argument

[valmunos]

What happens?

DuckDB version: 1.4.2 (python)

I tried attaching a postgres database using the following command:

duckdb.execute(f"""
    ATTACH 'dbname=postgres host={host} user=postgres password={password} sslmode=allow'
    AS pgdb (TYPE POSTGRES);
""")

The same arguments work just fine when I use the psycopg library, but I'm getting the following error message:

---------------------------------------------------------------------------
IOException                               Traceback (most recent call last)
Cell In[11], line 1
----> 1 duckdb.execute(f"""
      2     ATTACH 'dbname=postgres host=<host> user=postgres password=<password> sslmode=allow'
      3     AS pgdb (TYPE POSTGRES);
      4 """)

IOException: IO Error: Unable to connect to Postgres at "dbname=postgres host=<host> user=postgres password=<password> sslmode=allow": connection to server at "<host>", port 5432 failed: FATAL:  pg_hba.conf rejects connection for host "<host>", user "postgres", database "postgres", no encryption
connection to server at "<host>", port 5432 failed: FATAL:  password authentication failed for user "postgres"

NOTE: I removed all sensitive data from the traceback

To Reproduce

See above.

OS:

Windows

PostgreSQL Version:

16.10

DuckDB Version:

1.4.2

DuckDB Client:

Python

Full Name:

Vincent Munos

Affiliation:

PolicyBind

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]

Scanner passes the connection string to libpq, so sslmode is handled the same way as with any other libpq-based client (supporting PGSSLMODE env var etc).

Closing this as answered, if the problem persists - please try it first with psql CLI and provide the details on discrepancies between psql and the scanner.