Skip to content

Can not attach postgresql db using postgres extension. #483

@woyodb

Description

@woyodb

Hi , I am trying to attach a postgresql db to duckdb. encounter an error as below:

process didn't exit successfully:  ../duckdb_test --nocapture (signal: 11, SIGSEGV: invalid memory reference)

And the following code indicated that the extension is loaded.

conn.execute_batch(r"Load postgres;")?;  

let ext_loaded: bool = conn.query_row("select loaded from duckdb_extensions() where extension_name = ? ", ["postgres_scanner"], |r| {
   r.get(0) 
})?;

println!("{ext_loaded}");   // it's true

And in the duckdb cli, I can do the attach action as expected. so, pls help me to get through this.

v1.2.1 8e52ec4395
Enter ".help" for usage hints.
Connected to a transient in-memory database.
Use ".open FILENAME" to reopen on a persistent database.

D attach 'postgres://postgres:[email protected]/my_db' as db (TYPE postgres);
// attach worked.

Thanks.

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions