search

majkinetor / au-packages

Chocolatey packages by majkinetor
https://gist.github.com/majkinetor/a700c70b8847b29ebb1c918d47ee4eb1
GNU General Public License v2.0
66 stars 45 forks source link

`postgrest` is shipped without DLLs it requires to run #245

Open develop7 opened 4 months ago

develop7 commented 4 months ago

Repro:

  1. Install Windows (e.g. Win10 LTSC 2021 evaluation), install chocolatey
  2. choco install postgrest, open C:\postgrest\ in Explorer
  3. double-click postgrest.exe

Expected: a console window would blink

What happens instead: a console window opens up, but also an message box complaining the LibPQ.dll is missing

VirtualBox_win10test_27_06_2024_15_17_57

In before "why PostgREST does not ship them along with the executable" — https://github.com/PostgREST/postgrest/pull/3469. TL;DR: it's not out job; we don't know where to get them canonically; EnterpriseDB (first obvious source of them) license doesn't allow to redistribute them.

UPD: sister issue in scoop — https://github.com/ScoopInstaller/Main/issues/5959

majkinetor commented 1 month ago

EnterpriseDB (first obvious source of them) license doesn't allow to redistribute them.

If EDB doesn't allow redistribution, then it can't be added to the choco package too. I think there is nothing one can do here except finding different source.

develop7 commented 1 month ago

https://ftp.postgresql.org/pub/odbc/versions.old/dll/psqlodbc_16_00_0000-x64.zip has required DLLs and, being really small, does not need to vendor and redistribute them. The fix is on the way to scoop.

develop7 commented 1 month ago

An half-ready hint to approach the issue in scoop:

https://github.com/scoopinstaller/Main/blob/f6e84a5c661f8cf0bb1e0f7fb0c01f0bc9383f15/bucket/postgrest.json#L27-L28