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

Thanks for the report. Fixed with 14.10-3.

@sampsoncrowley, make sure you have correct llvm and clang versions. v16 will not compile. Please downgrade to v15 on both packages. also the package installation assumes both packages are availabe with clang and llvm-config

@sampsoncrowley: I cannot reproduce. 14.10-2 compiles, tests and installs OK on my box.

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.