Top
Enterprise Postgres 18 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

-

iputils

Required for Mirroring Controller.

libcurl

Required when using OAuth authentication.

libnsl2

-

libicu

Provides collation support.

Install 60.x.

libgcc

-

libmemcached

Required when using Pgpool-II.

libselinux

Required for sepgsql.

libstdc++

-

libtool-ltdl

Required when using ODBC drivers.

libzstd

-

llvm

Versions 20.1.x, 19.1.x, 18.1.x, 17.0.x, 16.0.x, or 15.0.x,of llvm is required to run SQL with runtime compilation (just-in-time compilation).

Install the package that contains libLLVM-20.so, libLLVM-19.so, libLLVM-18.so, libLLVM-17.so, llibLLVM-16.so, or llibLLVM-15.so.

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

By default, version 19.1.x is used.

If you use a version other than 19.1.x, specify the version you want to use in the jit_provider parameter in postgresql.conf.

For example, use llvmjit-vsn20 when using version 20.1.x. 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 "PostgreSQL Documentation".

libcgroup-tools

Required when using parallel scan.

lz4-libs

-

ncurses-libs

-

net-tools

-

nss-softokn-freebl

-

numactl-libs

-

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

This is required when using PL/Python based on the Python 3 language, or when using semantic text search and automatic vectorization. Please install version 3.11.x.

rsync

Required when using Pgpool-II.

tcl

Required when using PL/Tcl.
Install 8.6.

unzip

-

xz-libs

-

zlib

-

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

-

iputils

Required for Mirroring Controller.

libcurl

Required when using OAuth authentication.

libnsl2

-

libicu

Provides collation support.

Install 67.x.

libgcc

-

libmemcached-awesome

Required when using Pgpool-II.

libselinux

Required for sepgsql.

libstdc++

-

libtool-ltdl

Required when using ODBC drivers.

liburing

Install 2.x.

libzstd

-

llvm

Versions 20.1.x, 19.1.x, 18.1.x, 17.0.x, 16.0.x, or 15.0.x of llvm is required to run SQL with runtime compilation (just-in-time compilation).

Install the package that contains libLLVM-20.so, libLLVM-19.so, llibLLVM-18.so, libLLVM-17.so, llibLLVM-16.so, or llibLLVM-15.so.

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

By default, version 19.1.x is used.

If you use a version other than 19.1.x, specify the version you want to use in the jit_provider parameter in postgresql.conf.

For example, use llvmjit-vsn20 when using version 20.1.x.

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

-

numactl-libs

-

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

This is required when using PL/Python based on the Python 3 language, or when using semantic text search and automatic vectorization. Please install version 3.11.x.

rsync

Required when using Pgpool-II.

tcl

Required when using PL/Tcl.
Install 8.6.

unzip

-

xz-libs

-

zlib

-

2.1.1.3 Packages Required for SLES 15

The following packages are required for operations on SLES 15.

Package name

Remarks

dstat

Required when using parallel scan.

gdb

-

glibc

-

glibc-32bit

-

iputils

Required for Mirroring Controller.

JRE 8

Required when using the installer, database multiplexing, and WebAdmin.
The following JREs are available:

  • Oracle JRE

    Use the 64-bit version.

  • OpenJDK Past the Java TCK (Technology Compatibility Kit)

libasound2

-

libaudit1

-

libbz2-1

Required when using pgBackRest.

libcurl4

Required when using OAuth authentication.

libfreebl3

-

libicu-suse65_1

Provides collation support.
Install 65.

libgcc

-

libltdl7

Required when using ODBC drivers.

liblz4-1

-

liblzma5

-

libmemcached

Required when using Pgpool-II.

libncurses5

-

libnuma1

-

libprotobuf-c1

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

libstdc++6

-

liburing2

-

libz1

-

libzstd1

-

llvm

Version 15.0.x of llvm is required to run SQL with runtime compilation (just-in-time compilation). Install the package that contains libLLVM.so.15. For example, the "libLLVM15" published in SUSE includes libLLVM.so.15.

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 "PostgreSQL Documentation".

libLLVM15

Install 15.0.x.

net-tools

-

pam

Required when using PAM authentication.

perl

Required when using PL/Perl.
Install 5.26.

python3

This is required when using PL/Python based on the Python 3 language, or when using semantic text search and automatic vectorization. Please install version 3.11.x.

rsync

Required when using Pgpool-II.

sysstat

Set up the sar command after installation.

tcl

Required when using PL/Tcl.
Install 8.6.

unzip

-