Package Details: postgresql14 14.17-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: 2025-03-12 12:32 (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

« First ‹ Previous 1 2 3 Next › Last »

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?

mrechte commented on 2022-07-20 06:28 (UTC)

Just recompiled 14.4 and could not reproduce the problem.

Erwin00 commented on 2022-07-19 10:01 (UTC)

There are problems with compiling the package. I'll provide here the errors given by the operation

« First ‹ Previous 1 2 3 Next › Last »