@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
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