@jimbob88 thanks a lot for the explanation.
Search Criteria
Package Details: postgresql14-docs 14.17-1
Package Actions
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.000000 |
First Submitted: | 2021-12-27 15:12 (UTC) |
Last Updated: | 2025-03-12 12:32 (UTC) |
Dependencies (14)
- clang15AUR (make)
- icu (icu-gitAUR) (make)
- krb5 (krb5-gitAUR) (make)
- libldap (libldap-gnutlsAUR) (make)
- libxml2 (libxml2-gitAUR, libxml2-2.9AUR) (make)
- libxslt (libxslt-gitAUR) (make)
- llvm15 (make)
- openssl (openssl-gitAUR, openssl-staticAUR) (make)
- pam (pam-selinuxAUR) (make)
- perl (perl-gitAUR) (make)
- python (python37AUR, python311AUR, python310AUR) (make)
- systemd (systemd-chromiumosAUR, systemd-fmlAUR, systemd-gitAUR, systemd-selinuxAUR) (make)
- tcl (tcl-fossilAUR, tcl84AUR) (make)
- zlib (zlib-ng-compat-gitAUR, zlib-gitAUR, zlib-ng-compat) (make)
Required by (0)
Sources (8)
mrechte commented on 2025-03-12 12:34 (UTC)
jimbob88 commented on 2025-03-07 15:17 (UTC)
@mrechte I bumped the version to release 14.17 here:
https://github.com/jimbob88/postgresql14-pkgbuild
Bumping to 14.14 This fixed many of the test errors for me for tzdata: 2024b
Update time zone data files to tzdata release 2024b (Tom Lane) § § This tzdata release changes the old System-V-compatibility zone names to duplicate the corresponding geographic zones; for example PST8PDT is now an alias for America/Los_Angeles. The main visible consequence is that for timestamps before the introduction of standardized time zones, the zone is considered to represent local mean solar time for the named location. For
example, in PST8PDT, timestamptz input such as 1801-01-01 00:00 would previously have been rendered as 1801-01-01 00:00:00-08, but now it is rendered as 1801-01-01 00:00:00-07:52:58.
Now I just get the following error with tzdata 2025a + 14.14:
make[1]: Leaving directory '/home/james/Documents/postgresql14/src/postgresql-14.14/src/test/regress'
make: *** [GNUmakefile:69: check] Error 2
make check failure: ./src/test/regress/regression.diffs
diff -U3 /home/james/Documents/postgresql14/src/postgresql-14.14/src/test/regress/expected/timestamptz.out /home/james/Documents/postgresql14/src/postgresql-14.14/src/test/regress/results/timestamptz.out
--- /home/james/Documents/postgresql14/src/postgresql-14.14/src/test/regress/expected/timestamptz.out 2024-11-11 22:47:15.000000000 +0000
+++ /home/james/Documents/postgresql14/src/postgresql-14.14/src/test/regress/results/timestamptz.out 2025-03-07 14:03:56.707328648 +0000
@@ -2280,7 +2280,7 @@
SELECT make_timestamptz(1846, 12, 10, 0, 0, 0, 'Asia/Manila') AT TIME ZONE 'UTC';
timezone
--------------------------
- Wed Dec 09 15:56:00 1846
+ Wed Dec 09 15:56:08 1846
(1 row)
SELECT make_timestamptz(1881, 12, 10, 0, 0, 0, 'Europe/Paris') AT TIME ZONE 'UTC';
==> ERROR: A failure occurred in check().
Aborting...
Which was resolved on the mailing list: https://www.postgresql.org/message-id/3081498.1737403740%40sss.pgh.pa.us
This was fixed in 20b4819d0e351767f7f123ebdb5be246bba1a1bf.
Postgres 14.17 successfully compiles and executes all tests on tzdata 2025a
jimbob88 commented on 2025-03-06 16:30 (UTC)
@mrechte Thank you for your advice and the prompt reply! Have a good day!
mrechte commented on 2025-03-06 07:51 (UTC)
@jimbob88 this problem is weird and also affects other versions (PG16 for instance). In order to build, there is no other solution than bypass the tests passing --nocheck option to makepkg.
jimbob88 commented on 2025-03-05 12:53 (UTC)
========================
3 of 212 tests failed.
========================
The differences that caused some tests to fail can be viewed in the
file "/home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress/regression.diffs". A copy of the test summary that you see
above is saved in the file "/home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress/regression.out".
make[1]: *** [GNUmakefile:126: check] Error 1
make[1]: Leaving directory '/home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress'
make: *** [GNUmakefile:69: check] Error 2
make check failure: ./src/test/regress/regression.diffs
diff -U3 /home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress/expected/date.out /home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress/results/date.out
--- /home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress/expected/date.out 2024-08-05 21:08:36.000000000 +0100
+++ /home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress/results/date.out 2025-03-05 12:39:54.516291354 +0000
@@ -1264,7 +1264,7 @@
SELECT DATE_TRUNC('MILLENNIUM', DATE '1970-03-20'); -- 1001-01-01
date_trunc
------------------------------
- Thu Jan 01 00:00:00 1001 PST
+ Thu Jan 01 00:00:00 1001 LMT
(1 row)
SELECT DATE_TRUNC('CENTURY', TIMESTAMP '1970-03-20 04:30:00.00000'); -- 1901
@@ -1288,13 +1288,13 @@
SELECT DATE_TRUNC('CENTURY', DATE '0002-02-04'); -- 0001-01-01
date_trunc
------------------------------
- Mon Jan 01 00:00:00 0001 PST
+ Mon Jan 01 00:00:00 0001 LMT
(1 row)
SELECT DATE_TRUNC('CENTURY', DATE '0055-08-10 BC'); -- 0100-01-01 BC
date_trunc
---------------------------------
- Tue Jan 01 00:00:00 0100 PST BC
+ Tue Jan 01 00:00:00 0100 LMT BC
(1 row)
SELECT DATE_TRUNC('DECADE', DATE '1993-12-25'); -- 1990-01-01
@@ -1306,13 +1306,13 @@
SELECT DATE_TRUNC('DECADE', DATE '0004-12-25'); -- 0001-01-01 BC
date_trunc
---------------------------------
- Sat Jan 01 00:00:00 0001 PST BC
+ Sat Jan 01 00:00:00 0001 LMT BC
(1 row)
SELECT DATE_TRUNC('DECADE', DATE '0002-12-31 BC'); -- 0011-01-01 BC
date_trunc
---------------------------------
- Mon Jan 01 00:00:00 0011 PST BC
+ Mon Jan 01 00:00:00 0011 LMT BC
(1 row)
--
diff -U3 /home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress/expected/timestamptz.out /home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress/results/timestamptz.out
--- /home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress/expected/timestamptz.out 2024-08-05 21:08:36.000000000 +0100
+++ /home/james/.cache/paru/clone/postgresql14/src/postgresql-14.13/src/test/regress/results/timestamptz.out 2025-03-05 12:39:54.864396876 +0000
@@ -293,12 +293,12 @@
Fri Feb 14 17:32:01 1997 PST
Sat Feb 15 17:32:01 1997 PST
Sun Feb 16 17:32:01 1997 PST
- Tue Feb 16 17:32:01 0097 PST BC
- Sat Feb 16 17:32:01 0097 PST
- Thu Feb 16 17:32:01 0597 PST
- Tue Feb 16 17:32:01 1097 PST
- Sat Feb 16 17:32:01 1697 PST
- Thu Feb 16 17:32:01 1797 PST
+ Tue Feb 16 17:32:01 0097 LMT BC
+ Sat Feb 16 17:32:01 0097 LMT
+ Thu Feb 16 17:32:01 0597 LMT
+ Tue Feb 16 17:32:01 1097 LMT
+ Sat Feb 16 17:32:01 1697 LMT
+ Thu Feb 16 17:32:01 1797 LMT
Tue Feb 16 17:32:01 1897 PST
Sun Feb 16 17:32:01 1997 PST
Sat Feb 16 17:32:01 2097 PST
@@ -322,19 +322,19 @@
SELECT '4714-11-24 00:00:00+00 BC'::timestamptz;
timestamptz
---------------------------------
- Sun Nov 23 16:00:00 4714 PST BC
+ Sun Nov 23 16:07:02 4714 LMT BC
(1 row)
SELECT '4714-11-23 16:00:00-08 BC'::timestamptz;
timestamptz
---------------------------------
- Sun Nov 23 16:00:00 4714 PST BC
+ Sun Nov 23 16:07:02 4714 LMT BC
(1 row)
SELECT 'Sun Nov 23 16:00:00 4714 PST BC'::timestamptz;
timestamptz
---------------------------------
- Sun Nov 23 16:00:00 4714 PST BC
+ Sun Nov 23 16:07:02 4714 LMT BC
(1 row)... (cut here)
==> ERROR: A failure occurred in check().
Aborting...
error: failed to build 'postgresql14-14.13-1 (postgresql14-libs postgresql14)':
error: packages failed to build: postgresql14-14.13-1 (postgresql14-libs postgresql14)
The original command I used was:
$ paru -S postgresql14
If useful, my system timezone is GMT.
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.
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
Start the service
Use the service