postgrest is shipped without DLLs it requires to run

[develop7]

Repro:

0. Install Windows (e.g. Win10 LTSC 2021 evaluation), install chocolatey
1. choco install postgrest, open C:\postgrest\ in Explorer
2. 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

In before "why PostgREST does not ship them along with the executable" — PostgREST/postgrest#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 — ScoopInstaller/Main#5959

[majkinetor]

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]

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]

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

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