PostgreSQL 15.3

[Davidnadejdin]

Please update to PostgreSQL 15.3. Because the old version of PostgreSQL 15.1 trying to load extensions(Postgis in my case) by using llibtiff.5.dylib which has been updated to libtiff.6.dylib

[Davidnadejdin]

@huyphams please 🥲

[patjakubik]

That would be great @huyphams

[njwest]

PostGIS should work if you spin up PSQL 14.3 via dbngin, although obv this is not ideal

[igorkasyanchuk]

does anyone have a solution for this error?

[huyphams]

Hmm are you using pg 15 @igorkasyanchuk ?

[igorkasyanchuk]

tried with PG16, 15 and 14. Only works with 14.

Caused by:
PG::UndefinedFile: ERROR:  could not load library "/Users/Shared/DBngin/postgresql/15.1/lib/postgis-3.so": dlopen(/Users/Shared/DBngin/postgresql/15.1/lib/postgis-3.so, 0x000A): Library not loaded: /usr/local/opt/libtiff/lib/libtiff.5.dylib (PG::UndefinedFile)
  Referenced from: <6AAD9711-1CB0-3BCD-BCE9-F990AC56DBCD> /Users/Shared/DBngin/postgresql/15.1/lib/libproj.25.dylib
  Reason: tried: '/usr/local/opt/libtiff/lib/libtiff.5.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/opt/libtiff/lib/libtiff.5.dylib' (no such file), '/usr/local/opt/libtiff/lib/libtiff.5.dylib' (no such file), '/usr/lib/libtiff.5.dylib' (no such file, not in dyld cache), '/usr/local/Cellar/libtiff/4.6.0/lib/libtiff.5.dylib' (no such file), '/System/Volumes/Preboot/Cryptexes/OS/usr/local/Cellar/libtiff/4.6.0/lib/libtiff.5.dylib' (no such file), '/usr/local/Cellar/libtiff/4.6.0/lib/libtiff.5.dylib' (no such file), '/usr/lib/libtiff.5.dylib' (no such file, not in dyld cache)
/Users/igorkasyanchuk/projects/megakadastr/db/schema.rb:16:in `block in <main>'
/Users/igorkasyanchuk/projects/megakadastr/db/schema.rb:13:in `<main>'
Tasks: TOP => db:schema:load