Package Details: mingw-w64-postgresql 17.5-1

Git Clone URL: https://aur.archlinux.org/mingw-w64-postgresql.git (read-only, click to copy)
Package Base: mingw-w64-postgresql
Description: Sophisticated object-relational DBMS (mingw-w64)
Upstream URL: https://www.postgresql.org
Keywords: mingw mingw-w64 postgresql postgresql-libs
Licenses: custom:PostgreSQL
Conflicts: mingw-w64-postgresql-libs
Provides: mingw-w64-postgresql-libs
Replaces: mingw-w64-postgresql-libs
Submitter: Schala
Maintainer: Martchus
Last Packager: Martchus
Votes: 14
Popularity: 0.000000
First Submitted: 2016-08-19 22:49 (UTC)
Last Updated: 2025-05-24 22:05 (UTC)

Pinned Comments

Martchus commented on 2017-06-03 13:19 (UTC) (edited on 2019-01-28 13:06 (UTC) by Martchus)

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

Latest Comments

« First ‹ Previous 1 2 3 4 5 Next › Last »

Martchus commented on 2019-01-28 12:24 (UTC) (edited on 2019-01-28 12:26 (UTC) by Martchus)

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).

luntik2012 commented on 2019-01-28 12:10 (UTC)

the same error. any updates?

doragasu commented on 2019-01-28 07:17 (UTC) (edited on 2019-01-28 07:20 (UTC) by doragasu)

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

Martchus commented on 2018-12-08 18:32 (UTC)

I was able to build the latest version. Not sure what is different in your case. You can checkout the .BUILDINFO of https://martchus.no-ip.biz/repo/arch/ownstuff/os/x86_64/mingw-w64-postgresql-11.1-1-any.pkg.tar.xz to find out what's different in your build environment.

mkoloberdin commented on 2018-12-08 17:53 (UTC)

I am getting a linker error message:

/usr/lib/gcc/i686-w64-mingw32/8.2.0/../../../../i686-w64-mingw32/bin/ld: libpqwalreceiver.o: in function `libpqrcv_processTuples':
/tmp/yaourt-tmp-mike/aur-mingw-w64-postgresql/src/postgresql-11.1/build-i686-w64-mingw32/../src/backend/replication/libpqwalreceiver/libpqwalreceiver.c:882: undefined reference to `AllocSetContextCreateExtended'
collect2: error: ld returned 1 exit status

Martchus commented on 2018-11-30 16:41 (UTC)

I rebuilt the package yesterday for the 11.1 update without build errors. Is the error gone for you, too?

luntik2012 commented on 2018-11-29 14:52 (UTC)

identical errors in 1557-1590 lines aur-mingw-w64-postgresql/src/postgresql-10.5/build-i686-w64-mingw32/../src/timezone/data/tzdata.zi", line 1590: Invalid rule name "+"

Martchus commented on 2017-06-03 13:19 (UTC) (edited on 2019-01-28 13:06 (UTC) by Martchus)

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

Martchus commented on 2017-06-03 13:19 (UTC)

I guess I was able to build because I always build in a clean chroot. I'll include the PATH when updating anyways - currently I'm working on Qt 5.9.

xantares commented on 2017-06-03 08:58 (UTC)

hi, xml2-config is found in /usr/bin and returns host libxml2 includes and fails to build, to fix it to use target /usr/$arch/bin/xml2-config use: PATH=/usr/${_arch}/bin:$PATH ${_arch}-configure xan.

« First ‹ Previous 1 2 3 4 5 Next › Last »