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

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

Please don't flag packages in case of a "compilation error for about two months". The problem was initially only reported by one user so I assumed that it would be a local issue and didn't care too much. Besides the initial comment was not even including the linker invocation itself. How should I investigate a linker error without knowing the linker flags?

My own build conduced in a clean chroot succeeded. I assume you guys all didn't use a clean chroot and are instead building the package while the previous version is still installed on the system. Can you at least try to uninstall the previous version before? Judging by the linker line from @doragasu comment I assume gcc/ld will pick up the installed version rather than the newly built version. That seems to be a limitation of PostgreSQL's build system. It wouldn't be the first package of that kind (e.g. Qt's build system suffers from the same problem).

the same error. any updates?

I am also consistently having a linker error issue:

i686-w64-mingw32-gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Wendif-labels -Wmissing-format-attribute -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -O2 -pipe -fno-plt -fexceptions --param=ssp-buffer-size=4    -shared -static-libgcc -o libpqwalreceiver.dll  libpqwalreceiver.o win32ver.o -L../../../../src/port -L../../../../src/common -L../../../../src/interfaces/libpq -lpq -Wl,-O1,--sort-common,--as-needed  -Wl,--allow-multiple-definition -Wl,--disable-auto-import -L/usr/i686-w64-mingw32/lib -L/usr/i686-w64-mingw32/lib -L/usr/i686-w64-mingw32/lib   -lintl -L../../../../src/backend -lpostgres -lpgcommon -lpgport -lintl -lxml2 -lssl -lcrypto -lz -lm  -lws2_32 -Wl,--export-all-symbols -Wl,--out-implib=liblibpqwalreceiver.dll.a
/usr/lib/gcc/i686-w64-mingw32/8.2.0/../../../../i686-w64-mingw32/bin/ld: libpqwalreceiver.o:libpqwalreceiver.c:(.text+0x143e): undefined reference to `AllocSetContextCreateExtended'
collect2: error: ld returned 1 exit status

Might be related to this: https://github.com/tada/pljava/issues/160