Hi,
Does the OpenBSD require some extra steps for loading postgresql server
extensions?
tmy@asteroid tmy $ psql -d jemma -U postgres
Password for user postgres:
psql (12.3)
Type "help" for help.
jemma=# create extension pgcrypto;
ERROR: could not load library "/usr/local/lib/postgresql/pgcrypto.so": Cannot
load specified object
jemma=# \du
List of roles
Role name | Attributes |
Member of
-----------+------------------------------------------------------------+-----------
jemma | | {}
postgres | Superuser, Create role, Create DB, Replication, Bypass RLS | {}
jemma=# \q
tmy@asteroid tmy $ ldd /usr/local/lib/postgresql/pgcrypto.so
/usr/local/lib/postgresql/pgcrypto.so:
Start End Type Open Ref GrpRef Name
0000168b6def7000 0000168b6df2e000 dlib 1 0 0
/usr/local/lib/postgresql/pgcrypto.so
0000168b2cbea000 0000168b2ccde000 rlib 0 1 0
/usr/lib/libc.so.95.1
0000168b9df22000 0000168b9e141000 rlib 0 1 0
/usr/lib/libcrypto.so.45.5
0000168b35403000 0000168b3541e000 rlib 0 1 0
/usr/lib/libz.so.5.0
tmy@asteroid tmy $ ls -l /usr/lib/libc.so.95.1 /usr/lib/libcrypto.so.45.5
/usr/lib/libz.so.5.0
-r--r--r-- 1 root bin 3564664 Oct 25 2019 /usr/lib/libc.so.95.1
-r--r--r-- 1 root bin 7188496 Oct 25 2019 /usr/lib/libcrypto.so.45.5
-r--r--r-- 1 root bin 239960 Jun 9 03:23 /usr/lib/libz.so.5.0
