Knowledge articles
Installation/Setup

This error occurs when the core files cannot be found in the /var/tmp directory (the default location for Fujitsu Enterprise Postgres core files set up by WebAdmin).

This can happen because, by default, Linux deletes from /var/tmp any content that has not been accessed for 30 days or more.

The directory to output core files is specified by the core_directory parameter in postgresql.conf. When you create an instance in WebAdmin, /var/tmp/xxxxx/yyyyy/core is set by default.

Resolution

Do one of the following:

• Specify a directory other than /var/tmp to output core files, then restart Fujitsu Enterprise Postgres.
• Modify the Linux OS environment so that contents of /var/tmp are not automatically deleted after 30 days.

Modifying the Linux default behavior

You can either remove the tmpwatch package (which is responsible for deleting content from /tmp and /var/tmp) or you disable the cron entry.

Please note that in some cases, you may not be able to remove the tmpwatch package, because of its dependencies, so you may want to disable the cron entry instead.

Removing the tmpwatch package

Execute one of the commands below:

# rpm -e tmpwatch

or

# yum remove tmpwatch

Disable the cron entry

Execute one of the commands below:

# mv /etc/cron.daily/tmpwatch /other/location/tmpwatch.bkp

or

# rm /etc/cron.daily/tmpwatch

For details, refer to Fujitsu Enterprise Postgres Installation and Setup Guide for Server > Chapter 4 - Setup > 4.2 - Preparations for setup > 4.2.2 - Preparing directories for resource placement [Linux version] [Windows version].

Applicable to

Product: Fujitsu Enterprise Postgres Standard Edition, Fujitsu Enterprise Postgres Advanced Edition

Versions: from 9.4

Architecture: X86, S390x

Operating System: Windows, Linux

This answer is based on the following environment and configuration:

• OS: RHEL 7
• Instance port number: 27500
• Client IP address: 192.168.93.10

Follow the steps below:

1. Add the entries below to postgresql.conf (* means listen on all adapters for a connection):

   listen_addresses = *
   port = 27500

2. Register and reload the ports you want to connect to with firewall-cmd.
   1. Register the port.

      firewall-cmd-zone = public-add-port = 27500/tcp-permanent

   2. Reload the port.

      firewall-cmd-reload

3. Create an entry in pg_hba.conf (host-based configuration file) that matches the client machine that you want to connect from.
   In the example below all machines on the 192.168.93.x subnet will match and use the md5 authentication method.

   host all all 192.168.93.0/24 md5

4. Restart Postgres for the setting to take effect.

   $pg_ctl restart -D instance_destination_directory

5. If the user's password is entered correctly, other hosts can connect.

For details, refer to Fujitsu Enterprise Postgres Installation and Setup Guide for Server > Chapter 4 - Setup > 4.4 - Configuring remote connections > 4.4.2 - When an instance was created with the initdb command [Linux version] [Windows version].

Applicable to

Product: Fujitsu Enterprise Postgres Standard Edition, Fujitsu Enterprise Postgres Advanced Edition

Versions: from 9.4

Architecture: X86, S390x

Operating System: Linux

The pg_stat_statements library is pre-installed (along with other modules) in the contrib folder of the installation folder, so no additional libraries are required to be installed.

Follow the steps below to configure Fujitsu Enterprise Postgres to use pg_stat_statements:

1. Open postgresql.conf, and edit the shared_preload_libraries setting so that pg_stat_statements is the first entry in the list (if other libraries are specified, separate them with commas)

   shared_preload_libraries = 'pg_stat_statements'

2. Restart the instance.

   pg_ctl restart -D instance_destination_directory

3. Connect to the database and execute the CREATE EXTENSION command, specifying pg_stat_statements as the parameter.
   This will capture metrics for that database which can be viewed by querying the pg_stat_statements view.

   psql -d postgres -c "CREATE EXTENSION pg_stat_statements"

Applicable to

Product: Fujitsu Enterprise Postgres Standard Edition, Fujitsu Enterprise Postgres Advanced Edition

Versions: from 9.4

Architecture: X86, S390x

Operating System: Linux

This error message is displayed when the Postgres server has not been stopped properly, and fails to clean up the lock file postmaster.pid. This lock file is created when Postgres is started to prevent double booting; normally the file is removed when the database is shut down.

To fix this issue, simply delete the postmaster.pid file, and then start the database agian.

The postmaster.pid file is located in the data directory. Its location is determied by the -D option of the pg_ctl command, or by the PG_DATA environment variable if the command/option was not specified.

Applicable to

Product: Fujitsu Enterprise Postgres Standard Edition, Fujitsu Enterprise Postgres Advanced Edition, PostgreSQL

Versions: from 9.4

Architecture: X86, S390x

Operating System: Linux

This error occurs when the port specified in the port setting of postgresql.conf could not be used by the database, which happened because it is already in use either by a running instance of the database or by some other software.

In order to fix this issue, you need to either:

• Identify the software that is using the port and check if it is running on the correct port - if it is not, then take the appropriate action.

  To check the software using the port, use the the netstat command and grep for the port number (you may need to install the net-tools package if it is not already installed):

  netstat -ltnp | grep -w ':27500'

-or-

• Change the port number to be used by the instance by modifying the port setting of postgresql.conf.

  Make sure that the setting is not commented (comments in the configuration file begin with #).

Applicable to

Product: Fujitsu Enterprise Postgres Standard Edition, Fujitsu Enterprise Postgres Advanced Edition, PostgreSQL

Versions: from 9.4

Architecture: X86, S390x

Operating System: Linux

Often, this error message is displayed when the correct path settings cannot be acquired using the PATH and LD_LIBRARY_PATH environment variables.

This may happen because of one of the following:

• The environment variables are not set to the FUJTISU Enterprise Postgres installation directory.
• The environment variables are set to the FUJTISU Enterprise Postgres installation directory, but the installation directory for the open-source PostgreSQL is listed first.

Example

If the path is set to /usr/bin as below, and the OSS PostgreSQL is installed in that directory, the paramters specific to Fujitsu Enterprise Postgres will not be processed:

PATH=/usr/bin

The environment variables PATH and LD_LIBRARY_PATH must not only list the Fujitsu Enterprise Postgres installation directory - they must do list it before the PostgreSQL installation directory:

• Linux, Solaris

  (assuming the Fujitsu Enterprise Postgres installation directory is /opt/fsepv12server64)

  export PATH=/opt/fsepv12server64/bin:$PATH
  export LD_LIBRARY_PATH=/opt/fsepv12server64/lib:$LD_LIBRARY_PATH

• Windows

  (assuming the Fujitsu Enterprise Postgres installation directory is C:\Program Files\Fujitsu\fsepv12server64)

  SET PATH = C:\Program Files\Fujitsu\fsepv12server64\bin;
             C:\Program Files\Fujitsu\fsepv12server64\lib;
             %PATH%

  For more information, refer to the following:

  • (For Linux) Fujitsu Enterprise Postgres Installation and Setup Guide for Server > 4.3 - Creating instances > 4.3.2 - Using the the initdb command > 4.3.2.2 - Creating an instance
  • (For Windows) Fujitsu Enterprise Postgres Installation and Setup Guide for Server > 4.3 - Creating instances > 4.3.2 - Using the initdb command > 4.3.2.1 - Creating an instance

  Applicable to

  Product: Fujitsu Enterprise Postgres Standard Edition, Fujitsu Enterprise Postgres Advanced Edition, PostgreSQL

  Versions: from 9.4

  Architecture: X86, S390x

  Operating System: Linux, Windows

The likely cause of this scenario is that the database is recovering from a crash or non-standard shutdown (such as immediate shutdown mode). You can verify whether it is in crash recovery mode by checking if the log file contains the message database system was not properly shut down; automatic recovery in progress.

If a crash recovery is in progress, you will need to wait until it is complete, at which point the database will start up normally.

You can reduce the time taken for crash recovery by increasing the frequency of checkpoints (reduce the values of max_wal_size and checkpoint_timeout in postgresql.conf to achieve that). But keep in mind that the higher the frequency of checkpoints, the higher the I/O load, so set an appropriate value for operational considerations.

Applicable to

Product: Fujitsu Enterprise Postgres Standard Edition, Fujitsu Enterprise Postgres Advanced Edition

Versions: from 9.4

Architecture: X86, S390x

Operating System: Linux, Windows

Follow the steps below:

1. In Windows, select All Programs or All Apps > Fujitsu > Uninstall (middleware).
2. In the Currently installed products tab, check the items listed in the Software Name column.
   The server and client are successfully installed if the items below are listed: ^*
   • Server
     • Fujitsu Enterprise Postgres Advanced Edition(64bit)
   • Client
     • Fujitsu Enterprise Postgres Client(32bit)
     • Fujitsu Enterprise Postgres Client(64bit)

*: The items displayed depend on the products you have installed. This article shows an example of installing Fujitsu Enterprise Postgres 13 Advanced Edition.

Applicable to

Product: Fujitsu Enterprise Postgres Standard Edition, Fujitsu Enterprise Postgres Advanced Edition

Versions: from 9.5

Architecture: X86

Operating System: Windows

Follow the steps below to set up and start the database server using server commands, follow the instructions below.

Step 1: Prerequisites

1. Create an instance administrator.
   To add a new user in Windows, select Administrative Tools > Computer Management, then create the user in Local Users and Groups. Note that this user should be Administrator with appropriate password.
2. Create the directories below:
   • Data storage destination (required)
     Example: C:\work\database
   • Transaction log storage destination (optional)
     Example: C:\work\transaction

Step 2: Create an instance using initdb

1. Open the command prompt as the instance administrator created earlier.
2. Update the PATH environment variable - add the bin and lib directories located under the server installation directory.

   C:\Program Files\Fujitsu\fsepv13server64>SET PATH=C:\Program Files\Fujitsu\fsepv13server64\bin;C:\Program Files\Fujitsu\fsepvl3server64\lib;%PATH%

3. Create a database cluster using initdb and specifying the data storage destination.

   C:\Program Files\FujitstAfsepv13server64>initdb -D C:\work\database\instl --waldir.C:\work\transaction\ins it --Ic-collate--C- --1c-ctype--C- --encodingUTF8

4. If successful, the message below is output.

   Success. You can now start the database server using:

Step 3: Start the database server

1. Register an instance in the Windows service.

   C:\Program Files\Fujitsu\fsepv13server64>pg_ct1 register -N "inst1" -U fepuser -P password -D C:\work\database\inst1

2. Start an instance either from Administrative Tools or using the pg_ctl start command.

   C:\Program Files\Fujltsu\fsepv13server64>pg_ctl start -D C:\work\database\instl
   waiting for server to start....2021-10-07 03:34:32.286 GAT (1572) WARNING: The license will expire in 90 days.
   2021-10-07 14:34:32.318 AEDT (1572] LOG: starting PostgreSQL 13.3, compiled by Visual C++ build 1927, 64-bit
   2021-10-07 14:34:32.324 AEDT [1572] LOG: listening on IPv6 address "::1", port 27500
   2021-10-07 14:34:32.324 AEDT (1572] LOG: listening on IPv4 address "127.0.0.1", port 27500
   2021-10-07 14:34:32.416 AEDT [12092] LOG: database system was shut down at 2021-10-07 14:33:22 AEDT (10100)
   2021-10.07 14:34:32.769 AEDT [1572) LOG: database system is ready to accept connections (11202)
    done
   server started

   For more information, refer to Fujitsu Enterprise Postgres Installation and Setup Guide for Server > Chapter 4 - Setup > 4.3 - Creating instances > 4.3.2 - Using the initdb command > 4.3.2.1 - Creating an instance [Windows version]

Step 4: Connect to the database using psql.

C:\Program Files\Fujitst\fsepv13server64>psql -d postgres
psql (13.3)
WARNING: Console code page (850) differs from Windows code page (1252)
         8-bit characters might not work correctly. See psql reference
         page 'Notes for Windows users' for details.
         Type 'help' for help. 

postgres=#

Applicable to

Product: Fujitsu Enterprise Postgres Standard Edition, Fujitsu Enterprise Postgres Advanced Edition

Versions: from 9.5

Architecture: X86

Operating System: Windows