Nevermind, seems this was a case of botched package installation, re-installing
postgresql-contrib package fixed file collisions and now loading extensions
work.
timo
Timo Myyrä <timo.my...@bittivirhe.fi> writes:
> 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
