Top
Enterprise Postgres 17 SP1 Installation and Setup Guide for Server

2.1.1 Required Packages

Describes the required packages.

2.1.1.1 Packages Required for RHEL8

The following packages are required for operations on RHEL8.

Package name

Remarks

alsa-lib

-

audit-libs

-

bzip2-libs

Required when using pgBackRest.

cyrus-sasl-lib

-

pcp-system-tools

Required when using parallel scan.

glibc

-

libnsl2

-

libicu

Provides collation support.

Install 60.x.

libgcc

-

libmemcached

Required when using Pgpool-II.

libstdc++

-

libtool-ltdl

Required when using ODBC drivers.

libzstd

-

llvm

Version 11.0.x of llvm is required to run SQL with runtime compilation (just-in-time compilation).

Install the package that contains libLLVM-11.so.

For example, version 11.0.x of "llvm-libs" published with Application Streams includes libLLVM-11.so.

Fujitsu Enterprise Postgres uses runtime compilation by default. If you do not want to use runtime compilation, turn off the jit parameter in postgresql.conf.You do not need to install llvm if you turn off the jit parameter.

If the jit parameter is on and llvm is not installed, an error may occur during SQL execution. For more information about runtime compilation, see "Just-in-Time Compilation (JIT)" in the PostgreSQL Documentation.

Note:

If JIT compilation using LLVM is performed on RHEL8, a verbose server message is logged one or more times on first query execution, for each associated database connection.

<Message>

ORC error: No callback manager available for s390x-ibm-linux

This error message results from a known deficiency in one of the features of the LLVM library for IBM Z, but this feature is not used by the server and the error does not otherwise affect LLVM operation.

To prevent this message from being logged, JIT compilation may be disabled, by setting the value "off" to the configuration variable "jit".

lz4-libs

-

ncurses-libs

-

net-tools

-

nss-softokn-freebl

-

opencryptoki

Required if transparent data encryption is used in conjunction with a hardware security module.
Install into default directory.

pam

Required when using PAM authentication.

perl-libs

Required when using PL/Perl.
Install 5.26.

protobuf-c

Required if using the Transparent Data Encryption feature when using a key management system as a keystore.
Install 1.3.0.

python3.11

Required for text semantic search and automated vectorization.

python39

Required when using PL/Python based on Python 3.
Install 3.9.x.

redhat-lsb

-

libselinux

Required for sepgsql.

tcl

Required when using PL/Tcl.
Install 8.6.

unzip

-

xz-libs

-

zlib

-

java-1.8.0-openjdk

Required when using the database multiplexing and WebAdmin.

2.1.1.2 Packages Required for RHEL9

The following packages are required for operations on RHEL9.

Package name

Remarks

alsa-lib

-

audit-libs

-

bzip2-libs

Required when using pgBackRest.

cyrus-sasl-lib

-

pcp-system-tools

Required when using parallel scan.

glibc

-

libnsl2

-

libicu

Provides collation support.

Install 67.

libgcc

-

libmemcached-awesome

Required when using Pgpool-II.

libstdc++

-

libtool-ltdl

Required when using ODBC drivers.

libzstd

-

llvm

Version 13 of llvm is required to run SQL using run-time compilation.

Install the package that contains libLLVM -13 .so.

For example, version 13.0 .x of "lvm-libs " published with Application Streams includes libLLVM -13 .so.

Fujitsu Enterprise Postgres is configured to use runtime compilation by default. If you do not want to use runtime compilation, turn off the jit parameter in postgresql.conf. If you turn off the jit parameter, you do not need to install llvm.

If the jit parameter is on and llvm is not installed, an error may occur during SQL execution. For more information about runtime compilation, see "Just-in-Time Compilation (JIT) "in the PostgreSQL Documentation.

lz4-libs

-

ncurses-libs

-

net-tools

-

nss-softokn-freebl

-

opencryptoki

Required if transparent data encryption is used in conjunction with a hardware security module.
Install into default directory.

pam

Required when using PAM authentication.

perl-libs

Required when using PL/Perl.
Install 5.32.

protobuf-c

Required if using the Transparent Data Encryption feature when using a key management system as a keystore.
Install 1.3.3.

python3

If you want to use PL/Python based on the Python 3 language, install 3.9.x.

If you want to use semantic text search and automatic vector conversion, install 3.11.x.

libselinux

Required for sepgsql.

tcl

Required when using PL/Tcl.
Install 8.6.

unzip

-

xz-libs

-

zlib

-

java-1.8.0-openjdk

Required when using the database multiplexing and WebAdmin

2.1.1.3 Packages Required for SLES 15

The following packages are required for operations on SLES 15.

Package name

Remarks

libasound2

-

libaudit1

-

dstat

Required when using parallel scan.

glibc

-

libgcc

-

libbz2-1

Required when using pgBackRest.

libicu-suse65_1

Provides collation support.
Install 65.

liblz4-1

-

libmemcached

Required when using Pgpool-II.

libstdc++6

-

libltdl7

Required when using ODBC drivers.

libzstd1

-

llvm

Install version 15.0.x of llvm to run SQL with runtime compilation (just-in-time compilation) and add the directory where the shared library libLLVM -*.so is located to the environment variable LD_LIBRARY_PATH.

Fujitsu Enterprise Postgres uses runtime compilation by default. If you do not want to use runtime compilation, turn off the jit parameter in postgresql.conf. You do not need to install llvm if you turn off the jit parameter.

If the jit parameter is on and llvm is not installed, an error may occur during SQL execution. For more information about runtime compilation, see "Just-in-Time Compilation (JIT)" in the PostgreSQL Documentation.

libLLVM15

Install version 15.0.x.

libncurses6

-

net-tools

-

libfreebl3

-

openCryptoki-64bit

Required if transparent data encryption is used in conjunction with a hardware security module.
Install into default directory.

pam

Required when using PAM authentication.

perl-libs

Required when using PL/Perl.
Install 5.26.

libprotobuf-c1

Required if using the Transparent Data Encryption feature when using a key management system as a keystore.
Install 1.3.2.

python3

If you want to use PL/Python based on the Python 3 language, install 3.6.x.

If you want to use semantic text search and automatic vector conversion, install 3.11.x.

sysstat

Required when using pgx_fjqssinf command. Set up the sar command after installation.

tcl

Required when using PL/Tcl.
Install 8.6.

liblzma5

-

zlib-devel

-

java-1_8_0-openjdk

Required when using the database multiplexing and WebAdmin.