Arch Linux User Repository

Introduction

This version may cohabit with other major versions, including the official one.

Data directory is /var/lib/postgres/data14

Initialize the database

su - postgres
. /opt/postgresql14/bin/pgenv.sh
initdb -k

Start the service

systemctl start postgresql14

Use the service

. /opt/postgresql14/bin/pgenv.sh
psql -U postgres

Failed to install the following packages. Manual intervention is required: postgresql14-libs - exit status 4

It seems this package is incompatible with the latest GCC; any way to fix it?

xml.c:1023:45: error: incompatible function pointer types passing 'void (void *, xmlErrorPtr)' (aka 'void (void *, struct _xmlError *)') to parameter of type 'xmlStructuredErrorFunc' (aka 'void (*)(void *, const struct _xmlError *)') [-Wincompatible-function-pointer-types]
        xmlSetStructuredErrorFunc((void *) errcxt, xml_errorHandler);
                                                   ^~~~~~~~~~~~~~~~
/usr/include/libxml2/libxml/xmlerror.h:898:29: note: passing argument to parameter 'handler' here
                                 xmlStructuredErrorFunc handler);
                                                        ^
xml.c:4542:55: error: incompatible function pointer types passing 'void (void *, xmlErrorPtr)' (aka 'void (void *, struct _xmlError *)') to parameter of type 'xmlStructuredErrorFunc' (aka 'void (*)(void *, const struct _xmlError *)') [-Wincompatible-function-pointer-types]
        xmlSetStructuredErrorFunc((void *) xtCxt->xmlerrcxt, xml_errorHandler);
                                                             ^~~~~~~~~~~~~~~~
/usr/include/libxml2/libxml/xmlerror.h:898:29: note: passing argument to parameter 'handler' here
                                 xmlStructuredErrorFunc handler);
                                                        ^
xml.c:4596:55: error: incompatible function pointer types passing 'void (void *, xmlErrorPtr)' (aka 'void (void *, struct _xmlError *)') to parameter of type 'xmlStructuredErrorFunc' (aka 'void (*)(void *, const struct _xmlError *)') [-Wincompatible-function-pointer-types]
        xmlSetStructuredErrorFunc((void *) xtCxt->xmlerrcxt, xml_errorHandler);
                                                             ^~~~~~~~~~~~~~~~
/usr/include/libxml2/libxml/xmlerror.h:898:29: note: passing argument to parameter 'handler' here
                                 xmlStructuredErrorFunc handler);
                                                        ^
xml.c:4739:55: error: incompatible function pointer types passing 'void (void *, xmlErrorPtr)' (aka 'void (void *, struct _xmlError *)') to parameter of type 'xmlStructuredErrorFunc' (aka 'void (*)(void *, const struct _xmlError *)') [-Wincompatible-function-pointer-types]
        xmlSetStructuredErrorFunc((void *) xtCxt->xmlerrcxt, xml_errorHandler);
                                                             ^~~~~~~~~~~~~~~~
/usr/include/libxml2/libxml/xmlerror.h:898:29: note: passing argument to parameter 'handler' here
                                 xmlStructuredErrorFunc handler);
                                                        ^
4 errors generated.
make[4]: *** [../../../../src/Makefile.global:1084: xml.bc] Error 1
make[4]: Leaving directory '/home/sampson/.cache/yay/postgresql14/src/postgresql-14.10/src/backend/utils/adt'
make[3]: *** [../../../src/backend/common.mk:39: adt-recursive] Error 2
make[3]: Leaving directory '/home/sampson/.cache/yay/postgresql14/src/postgresql-14.10/src/backend/utils'
make[2]: *** [common.mk:39: utils-recursive] Error 2
make[2]: Leaving directory '/home/sampson/.cache/yay/postgresql14/src/postgresql-14.10/src/backend'
make[1]: *** [Makefile:42: all-backend-recurse] Error 2
make[1]: Leaving directory '/home/sampson/.cache/yay/postgresql14/src/postgresql-14.10/src'
make: *** [GNUmakefile:16: world-src-recurse] Error 2
==> ERROR: A failure occurred in build().
    Aborting...
 -> error making: postgresql14-exit status 4

Remove makedepends=perl and optdepends=perl.

Please kindly remove makedepends=perl and optdepends=perl as well.

Release 14.10. Removed --with-perl which was failing tests.

Release 14.9. Does not pass tests on my machine despite requiring clang15/llvm15. If not required disable llvm (--with-llvm) in PKGBUILD.

diff --git a/PKGBUILD b/PKGBUILD
index 5f9af72..419aab3 100644
--- a/PKGBUILD
+++ b/PKGBUILD
@@ -120,7 +120,7 @@ package_postgresql14-libs() {

   # this utility is to be sourced in order to find proper libs and bins
   popd
-  install -m 755 ../pgenv.sh "${pkgdir}/opt/${pkgbase}/bin"
+  install -m 755 ./pgenv.sh "${pkgdir}/opt/${pkgbase}/bin"
 }

Thanks for reporting. 14.8 does not produce any error.

The build fails some tests:

+ERROR:  invalid value "ŞUB" for "MON"
+DETAIL:  The given value did not match any of the allowed values for this field.
 SELECT to_date('01 Şub 2010', 'DD TMMON YYYY');
-  to_date   
-------------
- 02-01-2010
-(1 row)
-
+ERROR:  invalid value "Şub" for "MON"
+DETAIL:  The given value did not match any of the allowed values for this field.
 SELECT to_date('1234567890ab 2010', 'TMMONTH YYYY'); -- fail
 ERROR:  invalid value "1234567890ab" for "MONTH"
 DETAIL:  The given value did not match any of the allowed values for this field.
==> ERROR: A failure occurred in check().
    Aborting...

Looking at this comment in psql13 https://aur.archlinux.org/packages/postgresql13#comment-870822 , it seems that this problem is caused by a newer version of perl and links to a patch

Dropped Python2 support, being not distributed anymore by Arch.

Just asking because I really don't want to install python2 just to compile this because Python 2 is eol since nearly 3 years - is it really necessary for compilation?