Arch Linux User Repository

Important note

This package must be built in a clean chroot or at least without the previous version being installed. Otherwise PostgeSQL's build system seems to pick up the installed version of certain libraries rather than the version produced by the current build. (You would get a linker error like undefined reference to 'AllocSetContextCreateExtended'.)

All my packages are managed at GitHub where you can also contribute directly: https://github.com/Martchus/PKGBUILDs There also exist a binary repository: https://martchus.no-ip.biz/repo/arch/ownstuff

Didn't take the pinned comment, I uninstalled it and did it in a clean chroot, and it compiled successfully, thanks :)

It compiled for me. Did you take note of the pinned comment?

There is a bug compiling this package:

/usr/lib/gcc/i686-w64-mingw32/15.1.0/../../../../i686-w64-mingw32/bin/ld: pl_exec.o:pl_exec.c:(.text+0x912a): undefined reference to ReleaseAllPlanCacheRefsInOwner' /usr/lib/gcc/i686-w64-mingw32/15.1.0/../../../../i686-w64-mingw32/bin/ld: pl_handler.o:pl_handler.c:(.text+0x574): undefined reference toReleaseAllPlanCacheRefsInOwner' /usr/lib/gcc/i686-w64-mingw32/15.1.0/../../../../i686-w64-mingw32/bin/ld: pl_handler.o:pl_handler.c:(.text+0x867): undefined reference to ReleaseAllPlanCacheRefsInOwner' /usr/lib/gcc/i686-w64-mingw32/15.1.0/../../../../i686-w64-mingw32/bin/ld: pl_handler.o:pl_handler.c:(.text+0x8ee): undefined reference toReleaseAllPlanCacheRefsInOwner' collect2: error: ld devolvió el estado de salida 1

The ZIC (bin/zic) is not recognized in the package() function. To fix that, let it compile and fail and modify config.status files with the ZIC variable (for each architecture) as "bin/zic" and do a makepkg -R and install with pacman -U. For example, you must modify 2 config files, one in ../build-i686-w64-mingw32/config.status ../build-x86_64-w64-mingw32/config.status with the ZIC variable with:

ZIC="/bin/zic"

@Martchus Sorry for taking this long to answer and you were right, I was using Manjaro at the time and OpenSSL was still outdated on their stable branch.

@davidalb97 Did you already upgrade to OpenSSL 3.0? I wouldn't be surprised if it doesn't work out of the box at this point. See my comment on https://aur.archlinux.org/packages/mingw-w64-openssl#comment-854834. For now I'd suggest to stick to OpenSSL at https://aur.archlinux.org/cgit/aur.git/commit/?h=mingw-w64-openssl&id=a085bc651de0c0941cfda9638619b8ff1d66338a. You can also just use my binary repository which is also still at OpenSSL 1.1. I will do a rebuild similar to https://archlinux.org/todo/openssl-30 at some point but it makes sense to do it in accordance with the regular packages (e.g. to be able to pick-up necessary patches in accordance without re-inventing the wheel).

Not building for me, you know where can I find these "eay32" or "crypto" libraries?

checking for library containing CRYPTO_new_ex_data... no
configure: error: library 'eay32' or 'crypto' is required for OpenSSL
==> ERROR: A failure occurred in build().
    Aborting...

@Onoketa I was able to build in a clean chroot and other users could build it as well. Hence I assume you've missed the pinned comment and have a previous version installed during the build. Also be aware that the static Qt 5 package won't build against the latest PostgreSQL yet: https://github.com/Martchus/PKGBUILDs/issues/94#issuecomment-585822593

/usr/lib/gcc/i686-w64-mingw32/9.2.0/../../../../i686-w64-mingw32/bin/ld: libpqwalreceiver.o:libpqwalreceiver.c:(.text+0x38b): undefined reference to pg_strtoint32' /usr/lib/gcc/i686-w64-mingw32/9.2.0/../../../../i686-w64-mingw32/bin/ld: libpqwalreceiver.o:libpqwalreceiver.c:(.text+0xcf5): undefined reference topg_strtoint32' /usr/lib/gcc/i686-w64-mingw32/9.2.0/../../../../i686-w64-mingw32/bin/ld: libpqwalreceiver.o:libpqwalreceiver.c:(.text+0x13e5): undefined reference to `AllocSetContextCreateInternal' collect2: ld returned 1 exit status

yes, it works after removing package. please, add this to pinned comment