postgres_scanner for windows

[Yousuf28]

I was trying to install postgres_scanner with R. I got following error.

dbToken <- DBI::dbConnect(duckdb::duckdb())

DBI::dbExecute(dbToken, 'INSTALL POSTGRES')
Error in duckdb_result():
! rapi_execute: Failed to run query
Error: HTTP Error: Failed to download extension "postgres_scanner" at URL "http://extensions.duckdb.org/v1.2.1/windows_amd64_mingw/postgres_scanner.duckdb_extension.gz" (HTTP 403)
Extension "postgres_scanner" is an existing extension.

For more info, visit https://duckdb.org/docs/extensions/troubleshooting/?version=v1.2.1&platform=windows_amd64_mingw&extension=postgres_scanner
Run rlang::last_trace() to see where the error occurred.

My understanding is that R duckdb package need very specific build and version, which is windows_amd64_mingw and v1.2.1 version.
I tried to build from https://github.com/duckdb/duckdb-postgres the repo with msys2 but got different error. So did not work for me
So, how do I get http://extensions.duckdb.org/v1.2.1/windows_amd64_mingw/postgres_scanner.duckdb_extension.gz this file?
Anyone have any luck building from source for windows that work with R?
Thanks in advance.

[denis-or]

Hi. I also had this problem. I didn't understand why the error occurred. In my case, could it actually be because it's on Windows ARM? Were you able to solve it?

[Yousuf28]

Hi. I also had this problem. I didn't understand why the error occurred. In my case, could it actually be because it's on Windows ARM? Were you able to solve it?

not really.