Package Details: postgresql14 14.13-1

Git Clone URL: https://aur.archlinux.org/postgresql14.git (read-only, click to copy)
Package Base: postgresql14
Description: Sophisticated object-relational DBMS
Upstream URL: https://www.postgresql.org/
Licenses: custom:PostgreSQL
Submitter: mrechte
Maintainer: mrechte
Last Packager: mrechte
Votes: 1
Popularity: 0.000000
First Submitted: 2021-12-27 15:12 (UTC)
Last Updated: 2024-08-13 07:30 (UTC)

Pinned Comments

mrechte commented on 2021-12-27 15:36 (UTC) (edited on 2021-12-28 10:34 (UTC) by mrechte)

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

Latest Comments

1 2 Next › Last »

mrechte commented on 2023-12-19 14:40 (UTC)

Thanks for the report. Fixed with 14.10-3.

shailesz commented on 2023-12-16 05:19 (UTC)

@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

mrechte commented on 2023-12-08 10:52 (UTC)

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

sampsoncrowley commented on 2023-12-02 16:28 (UTC)

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

mrechte commented on 2023-11-11 15:30 (UTC)

Remove makedepends=perl and optdepends=perl.

MarsSeed commented on 2023-11-11 14:50 (UTC) (edited on 2023-11-11 14:51 (UTC) by MarsSeed)

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

mrechte commented on 2023-11-11 14:29 (UTC)

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

mrechte commented on 2023-11-11 11:30 (UTC)

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

alu1 commented on 2023-07-30 14:38 (UTC)

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"
 }

mrechte commented on 2023-07-19 09:09 (UTC) (edited on 2023-07-19 09:10 (UTC) by mrechte)

Thanks for reporting. 14.8 does not produce any error.