Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

Sign up for GitHub

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Jump to bottom

Windows release 12.0.2 is linked against external DLLs, but doesn't bundle them or provide instructions on how to get them #3136

Open
develop7 opened this issue Dec 26, 2023 · 4 comments
Open

Windows release 12.0.2 is linked against external DLLs, but doesn't bundle them or provide instructions on how to get them #3136

develop7 opened this issue Dec 26, 2023 · 4 comments
Assignees
@develop7
Labels
windows Related to the Windows Operating System

Comments

@develop7
Copy link
Collaborator

Environment

  • PostgreSQL version: N/A
  • PostgREST version: 12.0.2
  • Operating system: Windows 10

Description of issue

postgrest.exe --help should output help text to the console; instead it doesn't start complaining this or that DLL is missing (6 of them total)

Reproducing:

  1. Install Windows 10 to a VM, wait for the "App Installer" app to update (provides winget command),
  2. Install PostgreSQL (I've used winget install PostgreSQL.PostgreSQL)
  3. Deploy PostgREST:
  4. run postgrest.exe --help

Notes

I've copied required DLLs out of the pgAdmin bundled with PostgreSQL, so here's the listing of a directory with working PostgREST:

PS C:\Users\vboxuser\Downloads\postgrest-v12.0.2-windows-x64\artifacts\postgrest-windows-x64> ls

    Directory: C:\Users\vboxuser\Downloads\postgrest-v12.0.2-windows-x64\artifacts\postgrest-windows-x64

Mode                 LastWriteTime         Length Name
----                 -------------         ------ ----
-a---           11/8/2023 12:36 PM        4566016 libcrypto-3-x64.dll
-a---           11/8/2023 12:36 PM        1851113 libiconv-2.dll
-a---           11/8/2023 12:36 PM         475769 libintl-9.dll
-a---           11/8/2023 12:22 PM         326144 libpq.dll
-a---           11/8/2023 12:36 PM         773120 libssl-3-x64.dll
-a---           11/8/2023 12:36 PM          52736 libwinpthread-1.dll
-a---          12/20/2023 11:46 PM       58726400 postgrest.exe
@steve-chavez steve-chavez added the windows Related to the Windows Operating System label Dec 31, 2023
@locktarr
Copy link

Faced the same problem. The DLL files was found in the following paths:
..\PostgreSQL\15\bin

  • libcrypto-3-x64.dll
  • libiconv-2.dll
  • libintl-9.dll
  • libssl-3-x64.dll
  • libwinpthread-1.dll

..\PostgreSQL\15\lib

  • libpq.dll

Just copy this DLLs in folder with postgrest.exe and it works as intended. This need to be fixed for sure, but I hope this helps to use it right now

@steve-chavez
Copy link
Member

Is it the same with chocolatey? https://community.chocolatey.org/packages/postgrest

I thought scoop/chocolatey handled dependencies.

@develop7
Copy link
Collaborator Author

develop7 commented Apr 24, 2024 via email •
edited by wolfgangwalther

@steve-chavez
Copy link
Member

Nix on Windows making progress! NixOS/nix#8901. Maybe there's a future where we can get a static binary for Windows too.

cc @wolfgangwalther

@develop7 develop7 self-assigned this Apr 26, 2024
@develop7 develop7 mentioned this issue May 1, 2024
Closed
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Assignees

@develop7 develop7

Labels
windows Related to the Windows Operating System
Milestone
No milestone
Development

Successfully merging a pull request may close this issue.

ci: bundle DLL dependencies for windows release develop7/postgrest
3 participants
@develop7 @steve-chavez @locktarr