Top
Enterprise Postgres 17 Installation and Setup Guide for Server

2.1 Required Operating System

One of the operating systems shown below is required in order to use Fujitsu Enterprise Postgres.

Note

SLES cannot be used if performing failover operation integrated with PRIMECLUSTER.

Information

  • 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

    -

    gdb

    Required to run FJQSS.

    pcp-system-tools

    Required when using parallel scan.

    glibc

    -

    glibc.i686

    -

    iputils

    Required for Mirroring Controller.

    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 17.0.x, 16.0.x, 15.0.x, 14.0.x, or 13.0.x of llvm is required to run SQL with runtime compilation (just-in-time compilation).

    Install the package that contains libLLVM-17.so, llibLLVM-16.so,llibLLVM-15.so, llibLLVM-14.so, or libLLVM-13.so.

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

    By default, version 17.0.x is used.

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

    For example, use llvmjit-vsn16 when using version 16.0.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

    -

    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

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

    redhat-lsb

    -

    rsync

    Required when using Pgpool-II.

    sudo

    -

    sysstat

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

    tcl

    Required when using PL/Tcl.
    Install 8.6.

    unzip

    -

    xz-libs

    -

    zlib

    -

  • 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

    -

    gdb

    Required to run FJQSS.

    pcp-system-tools

    Required when using parallel scan.

    glibc

    -

    glibc.i686

    -

    iputils

    Required for Mirroring Controller.

    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.

    libzstd

    -

    llvm

    Versions 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-17.so, llibLLVM-16.so, or llibLLVM-15.so.

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

    By default, version 17.0.x is used.

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

    For example, use llvmjit-vsn16 when using version 16.0.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

    -

    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

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

    rsync

    Required when using Pgpool-II.

    sudo

    -

    sysstat

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

    tcl

    Required when using PL/Tcl.
    Install 8.6.

    unzip

    -

    xz-libs

    -

    zlib

    -

  • 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 update 31 or later of the 64-bit version.

    • OpenJDK Past the Java TCK (Technology Compatibility Kit)

    libasound2

    -

    libaudit1

    -

    libbz2-1

    Required when using pgBackRest.

    libfreebl3

    -

    libicu

    Provides collation support.
    Install 65.

    libgcc

    -

    libltdl7

    Required when using ODBC drivers.

    liblz4-1

    -

    liblzma5

    -

    libmemcached

    Required when using Pgpool-II.

    libncurses5

    -

    libstdc++6

    -

    libstdc++6-32bit

    Required for silent installation.

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

    LLVM-libs

    Install version 5.0.2 or later.

    net-tools

    -

    pam

    Required when using PAM authentication.

    perl

    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.2.

    python3

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

    rsync

    Required when using Pgpool-II.

    sudo

    -

    sysstat

    Set up the sar command after installation.

    tcl

    Required when using PL/Tcl.
    Install 8.6.

    unzip

    -