Package Details: postgresql14-docs 14.10-2

Git Clone URL: https://aur.archlinux.org/postgresql14.git (read-only, click to copy)
Package Base: postgresql14
Description: HTML documentation for PostgreSQL
Upstream URL: https://www.postgresql.org/
Licenses: custom:PostgreSQL
Submitter: mrechte
Maintainer: mrechte
Last Packager: mrechte
Votes: 1
Popularity: 0.000006
First Submitted: 2021-12-27 15:12 (UTC)
Last Updated: 2023-11-11 15: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 »

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.

matrs commented on 2023-07-17 17:05 (UTC)

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

mrechte commented on 2022-11-02 09:19 (UTC)

Dropped Python2 support, being not distributed anymore by Arch.

nachfuellbar commented on 2022-11-01 19:34 (UTC)

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?