search

alitrack / duckdb_fdw

DuckDB Foreign Data Wrapper for PostgreSQL
MIT License
272 stars 18 forks source link

Enable concurrent connection #4

Closed nestarz closed 3 years ago

nestarz commented 3 years ago

Hello @alitrack,

Every time there is more than one connection I get the following error: ERROR: failed to open SQLite DB. rc=1 path=/var/lib/postgresql/database.duckdb

Do you know how i can set postgres to behave in read only mode when making a connection to the duckdb database so it can allow multiple connections ?

See https://github.com/cwida/duckdb/issues/77

nestarz commented 3 years ago

Following https://github.com/cwida/duckdb/issues/1343 it seems i need to make a connection as read-only but is this something to be done in postgres or inside the wrapper code ?

Thanks

alitrack commented 3 years ago

fixed