zonkyio / embedded-postgres-binaries

Lightweight bundles of PostgreSQL binaries with reduced size intended for testing purposes.
Apache License 2.0
138 stars 29 forks source link

need for pgcrypto in linux alpine binaries #1

Closed ptitcoutu closed 5 years ago

ptitcoutu commented 5 years ago

I use embedded postgres to test my application and it works well on mac but not on linux alpine because pgcrypto is not available in this configuration. What can I do to be able to use pgcrypto even in linux alpine ?

tomix26 commented 5 years ago

Maybe it is because the alpine version is compiled without the --with-openssl parameter. I'll check it out and try to fix it. Thanks for the report.

tomix26 commented 5 years ago

@ptitcoutu What functions and algorithms are you using? Because most of standard algorithms should be built-in.

tomix26 commented 5 years ago

I've already found the probable cause of the problem. The pgcrypto is part of additionally supplied modules. Info from the official documentation:

When building from the source distribution, these components are not built automatically, unless you build the "world" target

Link: https://www.postgresql.org/docs/current/static/contrib.html

tomix26 commented 5 years ago

Fixed versions 9.3.24-1, 9.4.19-1, 9.5.14-1, 9.6.10-1, 10.5.0-1 have been released.