PostgreSQL в Astralinux 1.8.1

Список пакетов Astralinux 1.8:

apt list | grep postgre

odbc-postgresql/stable,now 1:13.02.0000-2+b1 amd64 [installed]
postgresql-15-pghintplan/stable,now 1.5.0-astra0+ci6+b1 amd64 [installed]
postgresql-15-pgpool2/stable 4.3.3-astra.se2+ci1+b1 amd64
postgresql-15-pldebugger/stable,now 11-astra1+ci2+b1 amd64 [installed]
postgresql-15-plproxy/stable 2.10.0-3+ci5+b1 amd64
postgresql-15-postgis-3-scripts/stable 3.3.2-astra1+ci1+b1 all
postgresql-15-postgis-3/stable 3.3.2-astra1+ci1+b1 amd64
postgresql-15-smlar/stable 1.0.0-1astra4+ci13+b1 amd64
postgresql-15/stable,now 15.6-astra.se2 amd64 [installed]
postgresql-client-15/stable,now 15.6-astra.se2 amd64 [installed,automatic]
postgresql-client-common/stable,now 246astra3+ci1 all [installed,automatic]
postgresql-client/stable 15+246astra3+ci1 all
postgresql-common/stable,now 246astra3+ci1 all [installed,automatic]
postgresql-contrib/stable,now 15+246astra3+ci1 all [installed]
postgresql-plperl-15/stable,now 15.6-astra.se2 amd64 [installed]
postgresql-plpython3-15/stable,now 15.6-astra.se2 amd64 [installed]
postgresql-pltcl-15/stable,now 15.6-astra.se2 amd64 [installed,automatic]
postgresql-postgis-scripts/stable 3.3.2-astra1+ci1+b1 all
postgresql-postgis/stable 3.3.2-astra1+ci1+b1 amd64
postgresql-se-test-15/stable,now 15.6-astra.se2 all [installed]
postgresql/stable,now 15+246astra3+ci1 all [installed]

pgagent/stable,now 4.2.2-2+b1 amd64 [installed]

На основе каких версий сделан форк PostgreSQL в Astralinux 1.8:

psql
psql (15.6 (Debian 15.6-astra.se9))
Type "help" for help.

postgres=# select version();
version
-------------------------------------------------------------
PostgreSQL 15.6 (Debian 15.6-astra.se2) on x86_64-pc-linux-gnu, compiled by gcc (Astra 12.2.0-14.astra3) 12.2.0, 64-bit

postgres=# select tantor_edition();
tantor_edition
------------------------
'Tantor Basic Edition'

postgres=# select tantor_version();
tantor_version
----------------
'15.6.0'

Список расширений PostgreSQL 15.6 (Debian 15.6-astra.se9)

name | comment

--------------------+---------------------------------------------------------

address_standardizer
address_standardizer-3
address_standardizer_data_us
address_standardizer_data_us-3

adminpack | administrative functions for PostgreSQL

amcheck | functions for verifying relation integrity

autoinc | functions for autoincrementing fields

bloom | bloom access method - signature file based index

bool_plperl | transform between bool and plperl

bool_plperlu | transform between bool and plperlu

btree_gin | support for indexing common datatypes in GIN

btree_gist | support for indexing common datatypes in GiST

citext | data type for case-insensitive character strings

cube | data type for multidimensional cubes

dblink | connect to other PostgreSQL databases from within a database

dict_int | text search dictionary template for integers

dict_xsyn | text search dictionary template for extended synonym processing

earthdistance | calculate great-circle distances on the surface of the Earth

fasttrun | fast transaction-unsafe truncate

file_fdw | foreign-data wrapper for flat file access

fulleq | exact equal operation

fuzzystrmatch | determine similarities and distance between strings

hstore | data type for storing sets of (key, value) pairs

hstore_plperl | transform between hstore and plperl

hstore_plperlu | transform between hstore and plperlu

hstore_plpython3u | transform between hstore and plpython3u

insert_username | functions for tracking who changed a table

intagg | integer aggregator and enumerator (obsolete)

intarray | functions, operators, and index support for 1-D arrays of integers

isn | data types for international product numbering standards

jsonb_plperl | transform between jsonb and plperl

jsonb_plperlu | transform between jsonb and plperlu

jsonb_plpython3u | transform between jsonb and plpython3u

lo | Large Object maintenance

ltree | data type for hierarchical tree-like structures

ltree_plpython3u | transform between ltree and plpython3u

mchar | SQL Server text type

moddatetime | functions for tracking last modification time

old_snapshot | utilities in support of old_snapshot_threshold

pageinspect | inspect the contents of database pages at a low level

pg_buffercache | examine the shared buffer cache

pg_freespacemap | examine the free space map (FSM)

pg_hint_plan |

pg_prewarm | prewarm relation data

pg_stat_statements | track planning and execution statistics of all SQL statements

pg_surgery | extension to perform surgery on a damaged relation

pg_trgm | text similarity measurement and index searching based on trigrams

pg_visibility | examine the visibility map (VM) and page-level visibility info

pg_walinspect | functions to inspect contents of PostgreSQL Write-Ahead Log

pgagent | A PostgreSQL job scheduler (pgagent.deb)

pgcrypto | cryptographic functions

pgpool_adm | Administrative functions for pgPool

pgpool_recovery | recovery functions for pgpool-II for V4.3

pgpool_regclass | replacement for regclass

pgrowlocks | show row-level locking information

pgstattuple | show tuple-level statistics

pldbgapi | server-side support for debugging PL/pgSQL functions

plperl | PL/Perl procedural language

plperlu | PL/PerlU untrusted procedural language

plpgsql | PL/pgSQL procedural language

plpython3u | PL/Python3U untrusted procedural language

pltcl | PL/Tcl procedural language

pltclu | PL/TclU untrusted procedural language

postgis
postgis-3
postgis_raster
postgis_raster-3
postgis_sfcgal
postgis_sfcgal-3
postgis_tiger_geocoder
postgis_tiger_geocoder-3
postgis_topology
postgis_topology-3

postgres_fdw | foreign-data wrapper for remote PostgreSQL servers

refint | functions for implementing referential integrity (obsolete)

seg | type for representing line segments or floating-point intervals

smlar

sslinfo | information about SSL certificates

tablefunc | functions that manipulate whole tables, including crosstab

tcn | Triggered change notifications

tsm_system_rows | TABLESAMPLE method which accepts number of rows as a limit

tsm_system_time | TABLESAMPLE method which accepts time in milliseconds as a limit

unaccent | text search dictionary that removes accents

uuid-ossp | generate universally unique identifiers (UUIDs)

xml2 | XPath querying and XSLT

(85 rows)

Выделено то, что не установлено в ванильном postgresql.

fasttrun fulleq machar - расширения из Tantor SE1C

pgagent pldbgapi - не установлены по умолчанию в Tantor SE

hstore_plpython3u jsonb_plpython3u pg_hint_plan pg_prewarm установлены в Tantor SE

Расширения, которые есть в Tantor SE 16.1:

credcheck | credcheck - postgresql plain text credential checker

http | HTTP client for PostgreSQL, allows web page retrieval inside the database.

hypopg | Hypothetical indexes for PostgreSQL

jsonb_plpython3u | transform between jsonb and plpython3u

ltree_plpython3u | transform between ltree and plpython3u

orafce | Functions and operators that emulate a subset of functions and packages from the Oracle RDBMS

page_repair | Individual page reparing

pg_background | Run SQL queries in the background

pg_columnar | Citus Columnar extension

pg_hint_plan |

pg_partman | Extension to manage partitioned tables by time or ID

pg_qualstats | An extension collecting statistics about quals

pg_store_plans | track plan statistics of all SQL statements executed

pg_variables | session variables with various types

pg_wait_sampling | sampling based statistics of wait events

pgaudit | provides auditing functionality

pgauditlogtofile | pgAudit addon to redirect audit log to an independent file

pgq | Generic queue for PostgreSQL

Выделены расширения, которые не установлены в Tantor SE1C

Параметры конфигурации AL18 15.6:

BINDIR = /usr/lib/postgresql/15/bin
DOCDIR = /usr/share/doc/postgresql-doc-15
HTMLDIR = /usr/share/doc/postgresql-doc-15
INCLUDEDIR = /usr/include/postgresql
PKGINCLUDEDIR = /usr/include/postgresql
INCLUDEDIR-SERVER = /usr/include/postgresql/15/server
LIBDIR = /usr/lib/x86_64-linux-gnu
PKGLIBDIR = /usr/lib/postgresql/15/lib
LOCALEDIR = /usr/share/locale
MANDIR = /usr/share/postgresql/15/man
SHAREDIR = /usr/share/postgresql/15
SYSCONFDIR = /etc/postgresql-common
PGXS = /usr/lib/postgresql/15/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE = '--build=x86_64-linux-gnu' '--prefix=/usr' '--includedir=${prefix}/include' '--mandir=${prefix}/share/man' '--infodir
=${prefix}/share/info' '--sysconfdir=/etc' '--localstatedir=/var' '--disable-option-checking' '--disable-silent-rules' '--libdir=$
{prefix}/lib/x86_64-linux-gnu' '--runstatedir=/run' '--disable-maintainer-mode' '--disable-dependency-tracking' '--with-tcl' '--wi
th-perl' '--with-python' '--with-pam' '--with-openssl' '--with-libxml' '--with-libxslt' '--mandir=/usr/share/postgresql/15/man' '-
-docdir=/usr/share/doc/postgresql-doc-15' '--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share/' '--datadir=/usr/share/
postgresql/15' '--bindir=/usr/lib/postgresql/15/bin' '--libdir=/usr/lib/x86_64-linux-gnu/' '--libexecdir=/usr/lib/postgresql/' '--
includedir=/usr/include/postgresql/' '--with-extra-version= (Debian 15.6-astra.se2)' '--enable-nls' '--enable-thread-safety' '--en
able-debug' '--enable-dtrace' '--disable-rpath' '--with-uuid=e2fs' '--with-gnu-ld' '--with-gssapi' '--with-ldap' '--with-pgport=54
32' '--with-system-tzdata=/usr/share/zoneinfo' 'AWK=mawk' 'MKDIR_P=/bin/mkdir -p' 'PROVE=/usr/bin/prove' 'PYTHON=/usr/bin/python3'
'TAR=/bin/tar' 'XSLTPROC=xsltproc --nonet' 'CFLAGS=-g -O2 -ffile-prefix-map=/builds/AstraOS/buildsystem/tbs_build/postgresql-15/p
ostgresql-15-15.6=. -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer' 'LDFLAGS=-Wl,-z,relro -Wl,-
z,now' '--enable-tap-tests' '--with-icu' '--with-llvm' 'LLVM_CONFIG=/usr/bin/llvm-config-15' 'CLANG=/usr/bin/clang-15' '--with-lz4
' '--with-zstd' '--with-systemd' 'build_alias=x86_64-linux-gnu' 'CPPFLAGS=-Wdate-time -D_FORTIFY_SOURCE=2' 'CXXFLAGS=-g -O2 -ffile
-prefix-map=/builds/AstraOS/buildsystem/tbs_build/postgresql-15/postgresql-15-15.6=. -fstack-protector-strong -Wformat -Werror=for
mat-security'
CC = gcc
CPPFLAGS = -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2
CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attr
ibute -Wimplicit-fallthrough=3 -Wcast-function-type -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wn
o-format-truncation -Wno-stringop-truncation -g -g -O2 -ffile-prefix-map=/builds/AstraOS/buildsystem/tbs_build/postgresql-15/postg
resql-15-15.6=. -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer
CFLAGS_SL = -fPIC
LDFLAGS = -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-15/lib -Wl,--as-needed
LDFLAGS_EX =
LDFLAGS_SL =
LIBS = -lpgcommon -lpgport -lzstd -llz4 -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lm
VERSION = PostgreSQL 15.6 (Debian 15.6-astra.se2)

Параметры конфигурации одного из ванильных 16.8:

BINDIR = /usr/lib/postgresql/16/bin

DOCDIR = /usr/share/doc/postgresql-doc-16

HTMLDIR = /usr/share/doc/postgresql-doc-16

INCLUDEDIR = /usr/include/postgresql

PKGINCLUDEDIR = /usr/include/postgresql

INCLUDEDIR-SERVER = /usr/include/postgresql/16/server

LIBDIR = /usr/lib/x86_64-linux-gnu

PKGLIBDIR = /usr/lib/postgresql/16/lib

LOCALEDIR = /usr/share/locale

MANDIR = /usr/share/postgresql/16/man

SHAREDIR = /usr/share/postgresql/16

SYSCONFDIR = /etc/postgresql-common

PGXS = /usr/lib/postgresql/16/lib/pgxs/src/makefiles/pgxs.mk

CONFIGURE = '--build=x86_64-linux-gnu' '--prefix=/usr' '--includedir=${prefix}/include' '--mandir=${prefix}/share/man' '--infodir=${prefix}/share/info' '--sysconfdir=/etc' '--localstatedir=/var' '--disable-option-checking' '--disable-silent-rules' '--libdir=${prefix}/lib/x86_64-linux-gnu' '--runstatedir=/run' '--disable-maintainer-mode' '--disable-dependency-tracking' '--with-tcl' '--with-perl' '--with-python' '--with-pam' '--with-openssl' '--with-libxml' '--with-libxslt' '--mandir=/usr/share/postgresql/16/man' '--docdir=/usr/share/doc/postgresql-doc-16' '--sysconfdir=/etc/postgresql-common' '--datarootdir=/usr/share/' '--datadir=/usr/share/postgresql/16' '--bindir=/usr/lib/postgresql/16/bin' '--libdir=/usr/lib/x86_64-linux-gnu/' '--libexecdir=/usr/lib/postgresql/' '--includedir=/usr/include/postgresql/' '--with-extra-version= (Ubuntu 16.3-1.pgdg22.04+1)' '--enable-nls' '--enable-thread-safety' '--enable-debug' '--enable-dtrace' '--disable-rpath' '--with-uuid=e2fs' '--with-gnu-ld' '--with-gssapi' '--with-ldap' '--with-pgport=5432' '--with-system-tzdata=/usr/share/zoneinfo' 'AWK=mawk' 'MKDIR_P=/bin/mkdir -p' 'PROVE=/usr/bin/prove' 'PYTHON=/usr/bin/python3' 'TAR=/bin/tar' 'XSLTPROC=xsltproc --nonet' 'CFLAGS=-g -O2 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer' 'LDFLAGS=-Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -flto=auto -Wl,-z,relro -Wl,-z,now' '--enable-tap-tests' '--with-icu' '--with-llvm' 'LLVM_CONFIG=/usr/bin/llvm-config-15' 'CLANG=/usr/bin/clang-15' '--with-lz4' '--with-zstd' '--with-systemd' '--with-selinux' 'build_alias=x86_64-linux-gnu' 'CPPFLAGS=-Wdate-time -D_FORTIFY_SOURCE=2' 'CXXFLAGS=-g -O2 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security'

CC = gcc

CPPFLAGS = -Wdate-time -D_FORTIFY_SOURCE=2 -D_GNU_SOURCE -I/usr/include/libxml2

CFLAGS = -Wall -Wmissing-prototypes -Wpointer-arith -Wdeclaration-after-statement -Werror=vla -Wendif-labels -Wmissing-format-attribute -Wimplicit-fallthrough=3 -Wcast-function-type -Wshadow=compatible-local -Wformat-security -fno-strict-aliasing -fwrapv -fexcess-precision=standard -Wno-format-truncation -Wno-stringop-truncation -g -g -O2 -flto=auto -ffat-lto-objects -flto=auto -ffat-lto-objects -fstack-protector-strong -Wformat -Werror=format-security -fno-omit-frame-pointer

CFLAGS_SL = -fPIC

LDFLAGS = -Wl,-Bsymbolic-functions -flto=auto -ffat-lto-objects -flto=auto -Wl,-z,relro -Wl,-z,now -L/usr/lib/llvm-15/lib -Wl,--as-needed

LDFLAGS_EX =

LDFLAGS_SL =

LIBS = -lpgcommon -lpgport -lselinux -lzstd -llz4 -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lm

VERSION = PostgreSQL 16.3 (Ubuntu 16.3-1.pgdg22.04+1)

параметр -Wl повторяется дважды.

Параметры конфигурации Tantor SE 16.1:

BINDIR = /opt/tantor/db/16/bin

DOCDIR = /opt/tantor/db/16/share/doc/postgresql

HTMLDIR = /opt/tantor/db/16/share/doc/postgresql

INCLUDEDIR = /opt/tantor/db/16/include

PKGINCLUDEDIR = /opt/tantor/db/16/include/postgresql

INCLUDEDIR-SERVER = /opt/tantor/db/16/include/postgresql/server

LIBDIR = /opt/tantor/db/16/lib

PKGLIBDIR = /opt/tantor/db/16/lib/postgresql

LOCALEDIR = /opt/tantor/db/16/share/locale

MANDIR = /opt/tantor/db/16/share/man

SHAREDIR = /opt/tantor/db/16/share/postgresql

SYSCONFDIR = /opt/tantor/db/16/etc/postgresql

PGXS = /opt/tantor/db/16/lib/postgresql/pgxs/src/makefiles/pgxs.mk

CONFIGURE = '--prefix=/opt/tantor/db/16' '--enable-tap-tests' '--enable-nls=en ru' '--with-python' '--with-icu' '--with-lz4' '--with-zstd' '--with-ssl=openssl' '--with-ldap' '--with-pam' '--with-uuid=e2fs' '--with-libxml' '--with-libxslt' '--with-gssapi' '--with-selinux' '--with-systemd' '--with-llvm' 'CFLAGS=-O2 -pipe -Wno-missing-braces' 'LLVM_CONFIG=/usr/bin/llvm-config-11' 'CLANG=/usr/bin/clang-11' 'PYTHON=/usr/bin/python3'

CC = gcc

CPPFLAGS = -D_GNU_SOURCE -I/usr/include/libxml2

CFLAGS_SL = -fPIC

LDFLAGS = -L/usr/lib/llvm-11/lib -Wl,--as-needed -Wl,-rpath,'/opt/tantor/db/16/lib',--enable-new-dtags

LDFLAGS_EX =

LDFLAGS_SL =

LIBS = -lpgcommon -lpgport -lselinux -lzstd -llz4 -lxslt -lxml2 -lpam -lssl -lcrypto -lgssapi_krb5 -lz -lreadline -lpthread -lrt -ldl -lm

VERSION = PostgreSQL 16.1