Package Details: postgresql15-docs 15.7-2

Git Clone URL: https://aur.archlinux.org/postgresql15.git (read-only, click to copy)
Package Base: postgresql15
Description: HTML documentation for PostgreSQL
Upstream URL: https://www.postgresql.org/
Licenses: custom:PostgreSQL
Provides: postgresql
Submitter: mrechte
Maintainer: mrechte
Last Packager: mrechte
Votes: 1
Popularity: 0.012310
First Submitted: 2023-12-08 11:01 (UTC)
Last Updated: 2024-07-24 15:19 (UTC)

Dependencies (14)

Required by (316)

Sources (9)

Pinned Comments

mrechte commented on 2023-12-08 11:02 (UTC) (edited on 2023-12-26 14:39 (UTC) by mrechte)

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

Latest Comments

1 2 Next › Last »

mrechte commented on 2024-07-24 15:20 (UTC)

Release 2. Fixes xml regression test.

DimaCit commented on 2024-07-20 16:16 (UTC)

@mrechte I had the same issue as msrd0. The problem went away after I downgraded the package libxml2 to version 2.12.7.

hschletz commented on 2024-07-17 11:19 (UTC) (edited on 2024-07-17 11:34 (UTC) by hschletz)

I ran into the same build problem. Seems to be an occasional problem with libxml. Since I don't use the XML functionality, I removed the --with-libxml and --with-libxslt flags, and the tests ran without errors.

Warning: Upon reinstallation, the package suggested a dump-and-restore, possibly because of the removed functionality. It's a dev system without valuable data, and the databases kept working, but on a production database, it's advisable to create a dump before installing the modified package and restore afterwards.

Incorporating this change might be problematic because of the functionality loss, but people who don't use XML in their databases and want to run the tests can remove the lines manually.

fboerman commented on 2024-06-23 14:03 (UTC)

I have the same build error as @msrd0

mrechte commented on 2024-06-15 14:26 (UTC) (edited on 2024-06-15 14:27 (UTC) by mrechte)

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

msrd0 commented on 2024-06-14 09:35 (UTC)

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

mrechte commented on 2024-02-21 16:18 (UTC)

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

hschletz commented on 2024-02-19 10:24 (UTC) (edited on 2024-02-19 10:25 (UTC) by hschletz)

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".

xeruf commented on 2024-01-22 16:07 (UTC)

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

kescherAUR commented on 2023-12-26 16:02 (UTC)

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

1 2 Next › Last »