postgres extension not available for duckdb 1.2.0

[johnniemorrow]

Hi,

The postgres extension can't be installed for the latest version of duckdb 1.2.0. Is there a way to see the release version of an extension, and which version of duckdb it's compatible with?

Thanks,
John

$ ./duckdb -version
v1.2.0 5f5512b827
$ ./duckdb -c "install postgres"
IO Error:
Failed to install 'postgres_scanner'
The file was built specifically for DuckDB version '1b8c9023d0' and can only be loaded with that version of DuckDB. (this version of DuckDB is 'v1.2.0')

[carlopi]

This is expected to be solved, but for transient caching behavior, see duckdb/duckdb#16076 (comment), but it would be great if you could double check.

[johnniemorrow]

I'm still seeing the same error @carlopi - maybe it hasn't built all options yet, I'm running linux on aarch64:

# install
$  ~ curl --fail --location --progress-bar --output duckdb_cli-linux-aarch64.zip https://github.com/duckdb/duckdb/releases/download/v1.2.0/duckdb_cli-linux-aarch64.zip && unzip duckdb_cli-linux-aarch64.zip
################################################################################################################################################################################################################################### 100.0%
Archive:  duckdb_cli-linux-aarch64.zip
  inflating: duckdb                  
$  ~ ./duckdb -version
v1.2.0 5f5512b827


# no existing extensions
$  ~ ls -al ~/.duckdb
ls: cannot access '/home/johnnie/.duckdb': No such file or directory


# install postgres
$ ~ ./duckdb -c "INSTALL postgres"
IO Error:
Failed to install 'postgres_scanner'
The file was built specifically for DuckDB version '1b8c9023d0' and can only be loaded with that version of DuckDB. (this version of DuckDB is 'v1.2.0')


# created extension folder but no files
$  ~ tree ~/.duckdb
/home/johnnie/.duckdb
 |- extensions
     |- v1.2.0
        |- linux_arm64

4 directories, 0 files

[carlopi]

@johnniemorrow: this is now expected to be solved, could you give it another go? Thanks a lot

[johnniemorrow]

Yes, that's working now @carlopi - thanks very much!