Package Details: postgresql-devel 19devel-3

Git Clone URL: https://aur.archlinux.org/postgresql-devel.git (read-only, click to copy)
Package Base: postgresql-devel
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: 2022-03-04 13:00 (UTC)
Last Updated: 2026-03-30 08:17 (UTC)

Pinned Comments

mrechte commented on 2023-06-09 12:28 (UTC) (edited on 2024-03-28 11:03 (UTC) by mrechte)

Introduction

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

Data directory is /var/lib/postgres/data17devel

Initialize the database
su - postgres
. /opt/postgresql-devel/bin/pgenv.sh
initdb -k
Start the service
systemctl start postgresql-devel
Use the service
. /opt/postgresql-devel/bin/pgenv.sh
psql -U postgres
Tips for generating package

See comments in PKGBUILD

Latest Comments

1 2 Next › Last »

mrechte commented on 2026-03-30 08:18 (UTC)

Thanks @mkurz. Also added to PG18.

mkurz commented on 2026-03-29 18:03 (UTC)

This package is not working out of the box. You need to change PGMAJORVERSION to 19 in postgresql-check-db-dir otherwise the cluster does not start because you run into the error An old version of the database format was found.

Further you miss some dependencies now as well. --with-liburing requires liburing, --with-libnuma requires numactl, --with-libcurl requires curl (but in makedepends). You can just copy the depends and makedepends array from the postgresql package, I checked it, it is very similiar to yours but dependencies are maintained better: https://gitlab.archlinux.org/archlinux/packaging/packages/postgresql/-/blob/main/PKGBUILD?ref_type=heads Also it's better IMHO to have them line-per-line for easier diffing after a change:

depends=(
  bash
  glibc
  icu libicui18n.so libicuuc.so
  krb5 libgssapi_krb5.so
  libgcc libgcc_s.so
  libldap
  libstdc++ libstdc++.so
  liburing liburing.so
  libxml2 libxml2.so
  libxslt
  llvm-libs
  lz4 liblz4.so
  numactl libnuma.so
  openssl libcrypto.so libssl.so
  pam libpam.so
  systemd-libs libsystemd.so
  util-linux-libs
  zlib libz.so
  zstd libzstd.so
)
makedepends=(
  clang
  curl
  docbook-xml
  docbook-xsl
  llvm
  perl
  perl-ipc-run
  python
  readline
  systemd
  tcl
  util-linux
)

And one more thing: you can also add aarch64 to the arch array (I can confirm it works)

arch=('x86_64' 'aarch64')

Do not forget to update checksums:

updpkgsums && makepkg --printsrcinfo > .SRCINFO

Thank you!

mrechte commented on 2026-03-29 14:55 (UTC)

Thanks @mkurz for reporting. I shall add them to v18 too.

mkurz commented on 2026-03-29 14:38 (UTC)

Can you please add

--with-libcurl
--with-libnuma
--with-liburing

they are new since v18 and were added in the Arch package as well: https://gitlab.archlinux.org/archlinux/packaging/packages/postgresql/-/commit/50e1c07041a7ab4d7628ce216a65714d67f95071

also relevant https://gitlab.archlinux.org/archlinux/packaging/packages/postgresql/-/commit/e311714ea358aa0572d4f69434a3cc14a656555f

blackout commented on 2025-10-16 12:54 (UTC) 

/home/roman/.cache/paru/clone/postgresql-devel/PKGBUILD: line 37: cd: postgresql-18devel: No such file or directory
==> ERROR: A failure occurred in prepare().
    Aborting...
error: failed to build 'postgresql-devel-18devel-1 (postgresql-devel-libs postgresql-devel)':
error: packages failed to build: postgresql-devel-18devel-1 (postgresql-devel-libs postgresql-devel)

mrechte commented on 2023-11-11 15:03 (UTC)

Move to PG17 devel.

tburgey commented on 2023-08-26 13:12 (UTC) (edited on 2023-08-26 13:14 (UTC) by tburgey)

got when running makepkg

postgresql-devel/PKGBUILD: line 35: cd: postgresql-16beta1: No such file or directory

mrechte commented on 2023-06-09 12:28 (UTC) (edited on 2024-03-28 11:03 (UTC) by mrechte)

Introduction

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

Data directory is /var/lib/postgres/data17devel

Initialize the database
su - postgres
. /opt/postgresql-devel/bin/pgenv.sh
initdb -k
Start the service
systemctl start postgresql-devel
Use the service
. /opt/postgresql-devel/bin/pgenv.sh
psql -U postgres
Tips for generating package

See comments in PKGBUILD

mrechte commented on 2023-06-09 12:03 (UTC)

Moved to PG16 beta1

1 2 Next › Last »