Top
Enterprise Postgres 14 SP1 Installation and Setup Guide for Server
FUJITSU Software

2.1 Required Operating System

One of the operating systems shown below is required in order to use FUJITSU Enterprise Postgres. Check and use minor version, which is certified and currently supported by Red Hat or SUSE for IBM Power LE (POWER9 and POWER10).

Note

The sepgsql module, which is a PostgreSQL extension, can be used in RHEL8.

Information

  • The following packages are required for operations on RHEL8.

    Package name

    Remarks

    alsa-lib

    -

    audit-libs

    -

    cyrus-sasl-lib

    -

    pcp-system-tools

    Required when using parallel scan.

    gdb

    Required when using pgx_fjqssinf command.

    glibc

    -

    iputils

    Required for Mirroring Controller.

    libnsl2

    -

    libicu

    Provides collation support.
    Install 60.x.

    libgcc

    -

    libmemcached

    Required when using Pgpool-II.

    libstdc++

    -

    libtool-ltdl

    Required when using ODBC drivers.

    llvm

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

    Install the package that contains libLLVM-12.so, or libLLVM-11.so.

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

    By default, version 12.0.x is used.

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

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

    Failure to install llvm without turning off the jit parameter may result in an error when executing SQL. For more information about runtime compilation, see "Just-in-Time Compilation (JIT)" in the PostgreSQL Documentation.

    Note:

    If JIT compilation using LLVM11 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 powerpc64le-unknown-linux-gnu

    This error message results from a known deficiency in one of the features of the LLVM library for POWER, 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

    -

    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.6.x.

    rsync

    Required when using Pgpool-II.

    sysstat

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

    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. Use build 1.8.0.312.b07 or later for ppc64le architecture.

  • The following packages are required for operations on SLES 15.

    Package name

    Remarks

    dstat

    Required when using parallel scan.

    gdb

    Required when using pgx_fjqssinf command.

    glibc

    -

    iputils

    Required for Mirroring Controller.

    libaudit1

    -

    libgcc_s1

    -

    libicu-suse65_1

    Provides collation support.
    Install 65.

    liblz4-1

    -

    libmemcached

    Required when using Pgpool-II.

    libncurses6

    -

    libstdc++6

    -

    libz1

    -

    llvm

    Install version 7.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 14 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.

    Failure to install llvm without turning off the jit parameter may result in an error when executing SQL. For more information about runtime compilation, see "Just-in-Time Compilation (JIT)" in the PostgreSQL Documentation.

    libLLVM7

    Install version 7.0.x.

    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.

    sysstat

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

    tcl

    Required when using PL/Tcl.
    Install 8.6.

    java-1_8_0-openjdk

    Required when using the database multiplexing and WebAdmin. Use build 1.8.0.312 or later for ppc64le architecture.