AUR (en) - postgresql-src

Search Criteria

Enter search criteria

Search by

Keywords

Out of Date

Sort by

Sort order

Per page

Package Details: postgresql-src 15.2-1

Package Actions

Git Clone URL:	https://aur.archlinux.org/postgresql-src.git (read-only, click to copy)
Package Base:	postgresql-src
Description:	A sophisticated object-relational DBMS (from source, LTO enabled)
Upstream URL:	http://www.postgresql.org/
Licenses:	custom:PostgreSQL
Conflicts:	postgresql
Provides:	postgresql
Submitter:	gregbunk
Maintainer:	gregbunk
Last Packager:	gregbunk
Votes:	0
Popularity:	0.000000
First Submitted:	2016-09-30 12:26 (UTC)
Last Updated:	2023-02-15 16:17 (UTC)

Dependencies (14)

clang (clang8, clang-git, llvm-git, llvm-minimal-git)
krb5 (krb5-git, krb5-minimal-git)
llvm (llvm8, llvm-git, llvm-minimal-git)
openssl (openssl-hardened, openssl-static, quictls-openssl, openssl-git)
pam (pam-minimal-git, pam-selinux)
postgresql-src-libs
readline (readline-athame-git, readline-git)
openssl (openssl-hardened, openssl-static, quictls-openssl, openssl-git) (make)
perl (perl-git) (make)
python (nogil-python, python36, python32, python39, python38, python37, python311, python312) (make)
perl (perl-git) (optional) – for PL/Perl support
postgresql-old-upgrade (optional) – upgrade from previous major version using pg_upgrade
python (nogil-python, python36, python32, python39, python38, python37, python311, python312) (optional) – for PL/Python support
tcl (tcl85, tcl84, tcl-fossil, tcl-nothreading) (optional) – for PL/Tcl support

Required by (342)

adminer (requires postgresql) (optional)
adminer-editor (requires postgresql) (optional)
adminer-git (requires postgresql) (optional)
akkoma-bin (requires postgresql) (optional)
akonadi-git (requires postgresql) (make)
akonadi-git (requires postgresql) (optional)
akonadi-qt4 (requires postgresql) (make)
akonadi-qt4 (requires postgresql) (optional)
alerta (requires postgresql) (optional)
algernon (requires postgresql) (optional)
algernon-bin (requires postgresql) (optional)
anastasis (requires postgresql)
anastasis-git (requires postgresql)
anastasis-gtk (requires postgresql)
anastasis-gtk-git (requires postgresql)
armitage-git (requires postgresql)
arsse (requires postgresql) (optional)
arsse-git (requires postgresql) (optional)
asterisk (requires postgresql) (optional)
asterisk-cisco (requires postgresql) (optional)
asterisk-lts-18 (requires postgresql) (optional)
autobrr (requires postgresql) (optional)
bareos-filedaemon-postgresql-python-plugin (requires postgresql)
binnavi (requires postgresql)
binnavi-git (requires postgresql)
boundary (requires postgresql) (optional)
boxedwine (requires postgresql) (make)
boxedwine-git (requires postgresql) (make)
btcpayserver (requires postgresql) (optional)
calckey (requires postgresql)
camlistore (requires postgresql) (optional)
camlistore-git (requires postgresql) (optional)
capanalysis (requires postgresql)
carto-postgresql (requires postgresql)
check_postgres (requires postgresql) (optional)
citus (requires postgresql)
citus-git (requires postgresql)
clair (requires postgresql) (optional)
cms-germany-git (requires postgresql)
cms-git (requires postgresql)
codimd-git (requires postgresql) (optional)
concourse (requires postgresql) (optional)
concourse-git (requires postgresql) (optional)
copperspice (requires postgresql) (make)
copperspice-git (requires postgresql) (make)
cstore_fdw (requires postgresql)
cutehmi-external-meta (requires postgresql) (optional)
davical (requires postgresql) (optional)
dendrite (requires postgresql) (optional)
dendrite-libvips (requires postgresql) (optional)
diaspora-postgresql (requires postgresql) (optional)
diaspora-postgresql-git (requires postgresql) (optional)
discourse (requires postgresql) (optional)
documize-community-bin (requires postgresql) (optional)
dragonfireclient-git (requires postgresql) (make)
drogon (requires postgresql) (make)
drogon-git (requires postgresql)
edgedb (requires postgresql)
envizon-git (requires postgresql)
erpnext (requires postgresql) (optional)
etebase-server (requires postgresql) (optional)
etesync-server (requires postgresql) (optional)
etherdraw (requires postgresql) (optional)
etherpad-lite (requires postgresql) (optional)
explain (requires postgresql) (optional)
findomain-git (requires postgresql) (optional)
fluent-bit (requires postgresql) (make)
forgejo-git (requires postgresql) (optional)
frappe-bench (requires postgresql) (optional)
freshrss (requires postgresql) (optional)
funkwhale (requires postgresql)
funkwhale-venv (requires postgresql)
gasmeter (requires postgresql) (optional)
gdal-ecw (requires postgresql) (optional)
gdal1 (requires postgresql) (optional)
ghostfolio (requires postgresql)
gitea-git (requires postgresql) (optional)
gitlab-ee (requires postgresql) (make)
gitlab-ee (requires postgresql) (optional)
gnatcoll-postgres (requires postgresql)
gnunet (requires postgresql) (make)
gnunet (requires postgresql) (optional)
gnunet-git (requires postgresql) (make)
gnunet-git (requires postgresql) (optional)
gogs (requires postgresql) (optional)
gogs-git (requires postgresql) (optional)
grass (requires postgresql) (optional)
grass6 (requires postgresql)
gsa (requires postgresql)
gvmd (requires postgresql)
headscale (requires postgresql) (optional)
headscale-git (requires postgresql) (optional)
hockeypuck-git (requires postgresql)
hypopg (requires postgresql)
hypopg-git (requires postgresql)
immich (requires postgresql)
invidious-git (requires postgresql) (optional)
jackal (requires postgresql) (optional)
jackal-git (requires postgresql) (optional)
jdbc_fdw (requires postgresql)
joomla (requires postgresql) (optional)
kamailio (requires postgresql) (make)
kamailio-autheph-modules (requires postgresql) (make)
kamailio-berkeley-modules (requires postgresql) (make)
kamailio-cnxcc-modules (requires postgresql) (make)
kamailio-cpl-modules (requires postgresql) (make)
kamailio-dnssec-modules (requires postgresql) (make)
kamailio-erlang-modules (requires postgresql) (make)
kamailio-extra-modules (requires postgresql) (make)
kamailio-geoip-modules (requires postgresql) (make)
kamailio-geoip2-modules (requires postgresql) (make)
kamailio-ims-modules (requires postgresql) (make)
kamailio-json-modules (requires postgresql) (make)
kamailio-kazoo-modules (requires postgresql) (make)
kamailio-ldap-modules (requires postgresql) (make)
kamailio-lua-modules (requires postgresql) (make)
kamailio-memcached-modules (requires postgresql) (make)
kamailio-mongodb-modules (requires postgresql) (make)
kamailio-mono-modules (requires postgresql) (make)
kamailio-mysql-modules (requires postgresql) (make)
kamailio-outbound-modules (requires postgresql) (make)
kamailio-perl-modules (requires postgresql) (make)
kamailio-phonenum-modules (requires postgresql) (make)
kamailio-postgres-modules (requires postgresql)
kamailio-postgres-modules (requires postgresql) (make)
kamailio-presence-modules (requires postgresql) (make)
kamailio-python-modules (requires postgresql) (make)
kamailio-rabbitmq-modules (requires postgresql) (make)
kamailio-radius-modules (requires postgresql) (make)
kamailio-redis-modules (requires postgresql) (make)
kamailio-ruby-modules (requires postgresql) (make)
kamailio-sctp-modules (requires postgresql) (make)
kamailio-snmpstats-modules (requires postgresql) (make)
kamailio-sqlite-modules (requires postgresql) (make)
kamailio-systemd-modules (requires postgresql) (make)
kamailio-tls-modules (requires postgresql) (make)
kamailio-unixodbc-modules (requires postgresql) (make)
kamailio-utils-modules (requires postgresql) (make)
kamailio-websocket-modules (requires postgresql) (make)
kamailio-xml-modules (requires postgresql) (make)
kamailio-xmpp-modules (requires postgresql) (make)
kannel (requires postgresql) (make)
kannel (requires postgresql) (optional)
karaokemugen (requires postgresql)
karaokemugen-git (requires postgresql)
kea-git (requires postgresql) (make)
kea-git (requires postgresql) (optional)
keme (requires postgresql) (optional)
kingfisherqm (requires postgresql)
krecipes (requires postgresql) (optional)
libakonadi-git (requires postgresql) (make)
libakonadi-qt4 (requires postgresql) (make)
libpreludedb (requires postgresql) (optional)
librespeed-go (requires postgresql) (optional)
limesurvey (requires postgresql) (optional)
limesurvey2 (requires postgresql) (optional)
linhabu (requires postgresql) (optional)
listmonk (requires postgresql)
listmonk-bin (requires postgresql)
listmonk-git (requires postgresql)
lsky-pro (requires postgresql) (optional)
mantisbt (requires postgresql) (optional)
mastodon (requires postgresql)
mastodon-git (requires postgresql)
matrix-synapse-git (requires postgresql) (check)
mattermost-git (requires postgresql) (optional)
mediagoblin (requires postgresql) (optional)
mediagoblin-git (requires postgresql) (optional)
meowsql (requires postgresql) (optional)
meowsql-git (requires postgresql) (optional)
minetest-common-git (requires postgresql) (make)
minetest-git (requires postgresql) (make)
minetest-server-git (requires postgresql) (make)
miniflux-git (requires postgresql) (optional)
mirrorbrain (requires postgresql) (optional)
mirthconnect (requires postgresql) (optional)
misskey (requires postgresql)
modoboa (requires postgresql) (optional)
mongo_fdw (requires postgresql)
movim (requires postgresql) (optional)
movim-git (requires postgresql) (optional)
mseedindex (requires postgresql) (optional)
naviserver-postgres-connector (requires postgresql)
nbxplorer (requires postgresql)
netbox-git (requires postgresql) (optional)
newsmangler-git (requires postgresql) (optional)
nominatim (requires postgresql)
nzyme-bin (requires postgresql)
odbc_fdw (requires postgresql)
odoo (requires postgresql)
odyssey (requires postgresql) (make)
officelife-git (requires postgresql) (optional)
oml2 (requires postgresql) (optional)
onlyoffice-documentserver-bin (requires postgresql)
openacs (requires postgresql)
openuru-moss (requires postgresql)
osm2pgsql (requires postgresql) (optional)
osm2pgsql-git (requires postgresql) (make)
osm2pgsql-git (requires postgresql) (optional)
outline (requires postgresql) (optional)
p-rout-git (requires postgresql)
pagure-postgresql (requires postgresql)
paperless-ng (requires postgresql) (optional)
paperless-ngx (requires postgresql) (optional)
peertube (requires postgresql)
pg-spgist_hamming-git (requires postgresql)
pgadmin3 (requires postgresql) (make)
pgintcl (requires postgresql) (optional)
pgjwt-git (requires postgresql)
pglogical (requires postgresql)
pglogical2 (requires postgresql)
pgmodeler (requires postgresql)
pgroonga (requires postgresql) (make)
pgrouting (requires postgresql) (make)
pgsi (requires postgresql) (optional)
pgsphere (requires postgresql)
pgsql-backup (requires postgresql)
pgsql-ogr-fdw (requires postgresql) (make)
pgtap-git (requires postgresql)
pgtcl (requires postgresql)
pgtcl-ng (requires postgresql)
pguri (requires postgresql)
pgvector (requires postgresql)
pg_amqp (requires postgresql)
pg_auto_failover (requires postgresql)
pg_cjk_parser-git (requires postgresql)
pg_cron (requires postgresql) (make)
pg_export (requires postgresql)
pg_graphql (requires postgresql)
pg_hashids-git (requires postgresql)
pg_icu_ext-git (requires postgresql)
pg_partman (requires postgresql)
pg_partman-git (requires postgresql)
pg_qualstats-git (requires postgresql)
pg_repack (requires postgresql) (make)
pg_rum (requires postgresql)
pg_show_plans (requires postgresql)
pg_squeeze (requires postgresql)
pg_stat_kcache-git (requires postgresql)
pg_ulid (requires postgresql)
photoview (requires postgresql) (optional)
pipelinedb-git (requires postgresql)
pixelfed (requires postgresql) (optional)
pldebugger-git (requires postgresql)
pleroma (requires postgresql) (optional)
pleroma-bin (requires postgresql) (optional)
pleroma-git (requires postgresql) (optional)
plikd (requires postgresql) (optional)
pllua (requires postgresql)
plpgsql_check-git (requires postgresql)
plume (requires postgresql) (make)
plume (requires postgresql) (optional)
plume-postgres (requires postgresql)
plv8-bin (requires postgresql)
postgis-git (requires postgresql)
postgis-sfcgal (requires postgresql)
postgis-src (requires postgresql)
postgres-decoderbufs (requires postgresql) (make)
postgresql-debversion (requires postgresql)
postgresql-libversion (requires postgresql)
postgresql-multicorn (requires postgresql)
postgresql-orafce (requires postgresql)
postgresql-plsh (requires postgresql)
postgresql-semver (requires postgresql)
postgresql-topn (requires postgresql)
postgresql-tsearch-extras (requires postgresql)
postgresql-uint (requires postgresql)
postgresql-uint-git (requires postgresql)
postgresql-unit (requires postgresql)
postgresql-unit-git (requires postgresql)
postgresql-zson-git (requires postgresql)
postsqlforms (requires postgresql) (optional)
powa-archivist-git (requires postgresql)
powa-web-git (requires postgresql)
psqlodbc (requires postgresql) (make)
pufferpanel-bin (requires postgresql) (optional)
python-ivre (requires postgresql) (optional)
python-ivre-git (requires postgresql) (optional)
qgis-git (requires postgresql) (optional)
qt3 (requires postgresql) (make)
qt6-base-headless (requires postgresql) (make)
quasar-server (requires postgresql)
quasar-single (requires postgresql)
quassel-core-small (requires postgresql) (optional)
quassel-core-small-git (requires postgresql) (optional)
repmgr (requires postgresql) (make)
saga-gis (requires postgresql) (optional)
seiscomp (requires postgresql) (optional)
seiscomp-git (requires postgresql) (optional)
selfoss (requires postgresql) (optional)
selfoss-git (requires postgresql) (optional)
semaphore-git (requires postgresql) (optional)
sftpgo (requires postgresql) (optional)
sftpgo-bin (requires postgresql) (optional)
sftpgo-git (requires postgresql) (optional)
sharry (requires postgresql) (optional)
shlink (requires postgresql) (optional)
shmig-git (requires postgresql) (optional)
sisu (requires postgresql) (optional)
sisu-gem (requires postgresql) (optional)
sisu-git (requires postgresql) (optional)
smartmeter (requires postgresql) (optional)
sogo (requires postgresql) (optional)
sogo2 (requires postgresql) (optional)
soju-git (requires postgresql) (optional)
solarmeter (requires postgresql) (optional)
sonarqube-bin (requires postgresql) (optional)
sonarqube-lts (requires postgresql) (optional)
sope (requires postgresql) (optional)
sope2 (requires postgresql) (optional)
sphinx (requires postgresql) (optional)
sqls (requires postgresql) (optional)
stellar-core-git (requires postgresql)
stoq (requires postgresql) (optional)
stoqserver (requires postgresql)
supysonic (requires postgresql) (optional)
taler-exchange (requires postgresql)
taler-exchange-git (requires postgresql)
taler-merchant (requires postgresql)
taler-merchant-git (requires postgresql)
tde-tqt3 (requires postgresql) (make)
tde-tqt3 (requires postgresql) (optional)
tempus-framework (requires postgresql)
tempus-wps-server (requires postgresql)
tern (requires postgresql) (optional)
teslamate (requires postgresql)
timescaledb-git (requires postgresql)
timescaledb-toolkit (requires postgresql)
tt-rss-git (requires postgresql) (optional)
turtl-server-git (requires postgresql)
typecho (requires postgresql) (optional)
urweb-git (requires postgresql) (optional)
wal2json (requires postgresql)
wiki-js (requires postgresql) (optional)
wiki-js-git (requires postgresql) (optional)
zammad (requires postgresql) (optional)
zhparser (requires postgresql)
zotonic (requires postgresql)

Sources (6)

Latest Comments

chrbayer commented on 2020-10-22 11:24 (UTC) (edited on 2020-10-22 12:41 (UTC) by chrbayer)

I analyzed it a bit further. In the line

gcc -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -flto pg_repack.o pgut/pgut.o pgut/pgut-fe.o  -L/usr/lib -march=x86-64 -mtune=generic -O2 -pipe -fno-plt -flto -flto -L/usr/lib  -Wl,--as-needed -Wl,-rpath,'/usr/lib',--enable-new-dtags  -L/usr/lib -lpq -L/usr/lib/postgresql -lpgcommon -lpgport -lpthread -lssl -lcrypto -lz -lreadline -lrt -ldl -lm -o pg_repack

the symbols in libpgcommon.a and libpgport.a are not usable for whatever reason.

Looks like version 12.4 does not use lto which is thus not used for the pg_repack extension.

I found one hint: the static lib should not be build with ar but with gcc-ar instead and gcc-ranlib instead of ranlib, I'll try to test this this evening.

chrbayer commented on 2020-10-22 09:18 (UTC)

By the way, you need to add llvm and clang at least as make dependencies to be able to compile it in a clean environment.

gregbunk commented on 2020-10-22 08:22 (UTC)

No, I was not previously aware of pg_repack. Looks very cool. I'll take a look and see if I can see what's wrong.

chrbayer commented on 2020-10-21 22:39 (UTC) (edited on 2020-10-22 08:39 (UTC) by chrbayer)

Thank you very much! It worked mostly, I only have the problem that I need to rebuild the pg_repack extension (a missing symbol reminded me of that), but this does not build any more. Have you tried that? During restore I saw that I do need this in my setup :-) For 12.4 The re_repack builds just fine, for 13 the linker complains about some missing symbols like pg_printf and pg_stricmp...

gregbunk commented on 2020-10-21 16:49 (UTC)

Right now you need to do so manually. I stop the existing server, dump everything, save postgresql.conf and pg_hba.conf from the data directory, delete the data directory, upgrade, recreate the data directory and initialize using initdb (instructions in the Arch wiki), copy back the two conf files, start the server and reload everything. Sounds like a lot, but actually pretty straightforward.

chrbayer commented on 2020-10-21 16:46 (UTC)

Thanks for providing this! How do I upgrade from 12.4 since I have not seen a postgresql-old-upgrade version 12.4 somewhere?

intgr commented on 2018-11-20 20:08 (UTC)

Instead of --with-jit, the package should use --with-llvm to enable JIT support.

Arch Linux User Repository