Arch Linux User Repository

Introduction

This version may cohabit with other major versions, including the official one.

Data directory is /var/lib/postgres/data15

Initialize the database

su - postgres
. /opt/postgresql15/bin/pgenv.sh
initdb -k

Start the service

systemctl start postgresql15

Use the service

. /opt/postgresql15/bin/pgenv.sh
psql -U postgres

@msrd0 I just recompiled. Tests passed OK. I cannot reproduce. You may use makepg --nocheck

The package fails to compile for me since the last update:

make check failure: ./src/test/regress/regression.diffs
diff -U3 /home/msrd0/.cache/yay/postgresql15/src/postgresql-15.7/src/test/regress/expected/xml.out /home/msrd0/.cache/yay/postgresql15/src/postgresql-15.7/src/test/regress/results/xml.out
--- /home/msrd0/.cache/yay/postgresql15/src/postgresql-15.7/src/test/regress/expected/xml.out   2024-05-06 22:23:18.000000000 +0200
+++ /home/msrd0/.cache/yay/postgresql15/src/postgresql-15.7/src/test/regress/results/xml.out    2024-06-14 11:26:47.085270807 +0200
@@ -223,23 +223,13 @@
 DETAIL:  line 1: xmlParseEntityRef: no name
 <invalidentity>&</invalidentity>
                 ^
-line 1: chunk is not well balanced
-<invalidentity>&</invalidentity>
-                                ^
 SELECT xmlparse(content '<undefinedentity>&idontexist;</undefinedentity>');
 ERROR:  invalid XML content
 DETAIL:  line 1: Entity 'idontexist' not defined
 <undefinedentity>&idontexist;</undefinedentity>
                              ^
-line 1: chunk is not well balanced
-<undefinedentity>&idontexist;</undefinedentity>
-                                               ^
 SELECT xmlparse(content '<invalidns xmlns=''&lt;''/>');
-         xmlparse
----------------------------
- <invalidns xmlns='&lt;'/>
-(1 row)
-
+ERROR:  invalid XML content
 SELECT xmlparse(content '<relativens xmlns=''relative''/>');
             xmlparse
 --------------------------------
@@ -254,15 +244,8 @@
 line 1: Opening and ending tag mismatch: twoerrors line 1 and unbalanced
 <twoerrors>&idontexist;</unbalanced>
                                     ^
-line 1: chunk is not well balanced
-<twoerrors>&idontexist;</unbalanced>
-                                    ^
 SELECT xmlparse(content '<nosuchprefix:tag/>');
-      xmlparse
----------------------
- <nosuchprefix:tag/>
-(1 row)
-
+ERROR:  invalid XML content
 SELECT xmlparse(document '   ');
 ERROR:  invalid XML document
 DETAIL:  line 1: Start tag expected, '<' not found
@@ -992,15 +975,13 @@
 -- error messages, we suppress the DETAIL in this test.
 \set VERBOSITY terse
 SELECT xpath('/*', '<invalidns xmlns=''&lt;''/>');
-ERROR:  could not parse XML document
+ERROR:  invalid XML content at character 20
 \set VERBOSITY default
 -- Again, the XML isn't well-formed for namespace purposes
 SELECT xpath('/*', '<nosuchprefix:tag/>');
-ERROR:  could not parse XML document
-DETAIL:  line 1: Namespace prefix nosuchprefix on tag is not defined
-<nosuchprefix:tag/>
-                 ^
-CONTEXT:  SQL function "xpath" statement 1
+ERROR:  invalid XML content
+LINE 1: SELECT xpath('/*', '<nosuchprefix:tag/>');
+                           ^
 -- XPath deprecates relative namespaces, but they're not supposed to
 -- throw an error, only a warning.
 SELECT xpath('/*', '<relativens xmlns=''relative''/>');
==> ERROR: A failure occurred in check().
    Aborting...
 -> error making: postgresql15-exit status 4

@hschletz thanks for reporting. I though I had already fixed the issue. This should be OK now.

As libraries are installed into a non-default path, applications linked against libpq won't find it unless the official postgresql-libs package is installed too. pgenv.sh has a line with LD_LIBRARY_PATH commented out, but that would work only for shells that source the script, but not system services. To enable the library globally, create a file /etc/ld.so.conf.d/postgresql15.conf containing:

/opt/postgresql15/lib

Then run "ldconfig".

Getting very odd compilation failure despite everything looking successful:

============== shutting down postmaster               ==============
============== removing temporary instance            ==============

=======================
 All 212 tests passed. 
=======================

make[1]: Leaving directory '/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5/src/test/regress'
make -C ./src/backend generated-headers
make[1]: Entering directory '/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5/src/backend'
make -C catalog distprep generated-header-symlinks
make -C utils distprep generated-header-symlinks
make[2]: Entering directory '/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5/src/backend/utils'
make[2]: Nothing to be done for 'distprep'.
make[2]: Nothing to be done for 'generated-header-symlinks'.
make[2]: Leaving directory '/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5/src/backend/utils'
make[2]: Entering directory '/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5/src/backend/catalog'
make[2]: Nothing to be done for 'distprep'.
make[2]: Nothing to be done for 'generated-header-symlinks'.
make[2]: Leaving directory '/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5/src/backend/catalog'
make[1]: Leaving directory '/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5/src/backend'
rm -rf '/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5'/tmp_install
/usr/bin/mkdir -p '/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5'/tmp_install/log
make -C '.' DESTDIR='/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5'/tmp_install install >'/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5'/tmp_install/log/install.log 2>&1
make -j1  checkprep >>'/home/janek/.local/cache/yay/postgresql15/src/postgresql-15.5'/tmp_install/log/install.log 2>&1
make: *** [src/Makefile.global:412: temp-install] Error 2
==> ERROR: A failure occurred in check().
    Aborting...
 -> error making: postgresql15-exit status 4
 -> Failed to install the following packages. Manual intervention is required:
postgresql15-libs - exit status 4
postgresql11-libs - exit status 4
postgresql11 - exit status 4
postgresql15 - exit status 4

@mrechte You should also put perl back into the depends array from optdepends

Now includes --with-perl. Thanks to @kescherAUR.

This package may fail on two tests when uncommenting the --with-perl option with perl installed. Setting LANG=C before make "${1}" in _postgres_check fixes the issue. No idea if LC_ variables also need to be overridden if they are set.

Thanks for the report. Fixed in 15.5-4.

Experiencing the same issue as @fbrennan, this fails to build.