"Peter K. Stys" <pkstys@gmail.com> writes:
> I'd like to create a plugin with all pgsql libs statically linked into my
> plugin to create a standalone solution.
> I've added the libpq.a library and included libpq-fe.h and postgres_ext.h
> that it needs. The linker reports a bunch of errors:
> "_BIO_free", referenced from:
I believe that's openssl code. Unless you also have static libraries
for openssl, and any other libraries you've compiled libpq to depend on,
there is no hope of making a self-contained executable.
FWIW, most people realized that monolithic statically-linked executables
are a terrible idea about ten years ago. You have no idea the amount of
maintenance pain you are setting up for yourself and your users.
Do you really want to relink Postgres every time there's an openssl
security update?
regards, tom lane