Trying to use postgresql backend ends with:
prelude-manager[2111469]: 12 Feb 14:33:22 (process:2111469) WARNING:
/usr/lib/x86_64-linux-gnu/libpreludedb/plugins/sql/pgsql: file not found.
prelude-manager[2111469]: 12 Feb 14:33:22 (process:2111469) WARNING:
Option error: error initializing libpreludedb SQL interface: Could not
load sql plugin 'pgsql'.
prelude-manager[2111469]: 12 Feb 14:33:22 (process:2111469) INFO:
Subscribing Normalize to active decoding plugins.
prelude-manager[2111469]: 12 Feb 14:33:22 (process:2111469) INFO: server
started (listening on 127.0.0.1 port 4690).
prelude-manager[2111469]: 12 Feb 14:33:22 (process:2111469) INFO: server
started (listening on 192.168.1.xx port 4690).
systemd[1]: prelude-manager.service: Main process exited, code=exited,
status=255/EXCEPTION
systemd[1]: prelude-manager.service: Failed with result 'exit-code'.

Using mysql backend (libpreludedb7-mysql) works fine.
Although first warning (file not found) is returned regardless of used
driver.

Both libs are in the same place with same extensions and rigts:
/usr/lib/x86_64-linux-gnu/libpreludedb/plugins/sql
-rw-r--r--. 1 root root   947 2020-12-07  mysql.la
-rw-r--r--. 1 root root 22696 2020-12-07  mysql.so
-rw-r--r--. 1 root root   947 2020-12-07  pgsql.la
-rw-r--r--. 1 root root 26792 2020-12-07  pgsql.so

Expected behaviour: Be able to use both database backends.

My OS (up2date): VERSION="11 (bullseye)"

Can it be problem with:
ii  libpreludedb7-pgsql:amd64  5.2.0-1+b1
???

Under Centos-like distros, postgres backend is usable.

EPEL RPM:
preludedb-pgsql.x86_64  5.2.0-2.el9  @epel

[root@rocky ~]# rpm -ql preludedb-pgsql | grep pgsql.so
/usr/lib64/libpreludedb/plugins/sql/pgsql.so
Above driver is found by prelude-manager, loaded and used.
So if same upstrem sources were used, maybe problem is with Debian
libpq-dev package?

BTW: also trying pgsql driver with prewikka Debian package ends with:
/usr/lib/x86_64-linux-gnu/libpreludedb/plugins/sql/pgsql: file not found.
(also in 5.2.0-2 version under bookworm)

Centos is not planned - good to see prelude at production...

Dear submitter,

as the package prelude-manager has just been removed from the Debian archive
unstable we hereby close the associated bug reports.  We are sorry
that we couldn't deal with your issue properly.

For details on the removal, please see https://bugs.debian.org/1146557

The version of this package that was in Debian prior to this removal
can still be found using https://snapshot.debian.org/.

Please note that the changes have been done on the master archive and
will not propagate to any mirrors until the next dinstall run at the
earliest.

This message was generated automatically; if you believe that there is
a problem with it please contact the archive administrators by mailing
ftpmaster@ftp-master.debian.org.

Debian distribution maintenance software
pp.
Thorsten Alteholz (the ftpmaster behind the curtain)