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

« First ‹ Previous 1 2

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

mrechte commented on 2022-03-04 10:55 (UTC)

I just recompiled 14.2 and could not reproduce the problem.

howesteve commented on 2022-02-27 20:51 (UTC) (edited on 2022-02-27 20:51 (UTC) by howesteve)

This version has a build error. Is it just here??

 SET client_min_messages TO 'warning';
 DROP ROLE IF EXISTS regress_foreign_data_user, regress_test_role, regress_test_role2, regress_test_role_super, regress_test_indirect, regress_unprivileged_role;
+ERROR:  role "regress_test_role" cannot be dropped because some objects depend on it
+DETAIL:  owner of collation test_schema.test11
 RESET client_min_messages;
 CREATE ROLE regress_foreign_data_user LOGIN SUPERUSER;
 SET SESSION AUTHORIZATION 'regress_foreign_data_user';
 CREATE ROLE regress_test_role;
+ERROR:  role "regress_test_role" already exists
 CREATE ROLE regress_test_role2;
 CREATE ROLE regress_test_role_super SUPERUSER;
 CREATE ROLE regress_test_indirect;
==> ERROR: A failure occurred in check().
    Aborting...
 -> error making: postgresql14 (postgresql14-libs postgresql14)

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

« First ‹ Previous 1 2