Package Details: postgresql16 16.8-1

Git Clone URL: https://aur.archlinux.org/postgresql16.git (read-only, click to copy)
Package Base: postgresql16
Description: Sophisticated object-relational DBMS
Upstream URL: https://www.postgresql.org/
Licenses: custom:PostgreSQL
Provides: postgresql
Submitter: mrechte
Maintainer: mrechte
Last Packager: mrechte
Votes: 0
Popularity: 0.000000
First Submitted: 2025-02-12 16:35 (UTC)
Last Updated: 2025-03-12 12:50 (UTC)

Required by (389)

Sources (8)

Pinned Comments

mrechte commented on 2025-02-12 16:40 (UTC)

Introduction

Unfortunately, for some unknown reason, AUR maintainer refuses competition with the official package at the same major version.

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

Data directory is /var/lib/postgres/data16

Initialize the database
su - postgres
. /opt/postgresql16/bin/pgenv.sh
initdb -k
Start the service
systemctl start postgresql16
Use the service
. /opt/postgresql16/bin/pgenv.sh
psql -U postgres

Latest Comments

mrechte commented on 2025-02-21 17:51 (UTC)

Yes I know. It is weird to get such a time error.

In order to build, there is no other solution than bypass the tests passing --nocheck option to makepkg.

Tanghe commented on 2025-02-21 11:47 (UTC)

I have tried removing the timez dependancy and removing the checks but no matter what i do if get the following error.

@@ -2391,7 +2391,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... error: failed to build 'postgresql16-16.6-1 (postgresql16-libs postgresql16)': error: packages failed to build: postgresql16-16.6-1 (postgresql16-libs postgresql16)

mrechte commented on 2025-02-12 16:40 (UTC)

Introduction

Unfortunately, for some unknown reason, AUR maintainer refuses competition with the official package at the same major version.

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

Data directory is /var/lib/postgres/data16

Initialize the database
su - postgres
. /opt/postgresql16/bin/pgenv.sh
initdb -k
Start the service
systemctl start postgresql16
Use the service
. /opt/postgresql16/bin/pgenv.sh
psql -U postgres