Knowledge articles - Installation/Setup

The error message FATAL: Could not access directory for core file "/var/tmp/xxxxx/yyyyy/core": No such file or directory was displayed when starting Fujitsu Enterprise Postgres via WebAdmin.KB8001

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

# yum remove tmpwatch

Disable the cron entry

Execute one of the commands below:

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

# 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

How do I configure an initialized database instance (using initdb) so that a client can connect from a different machine?KB8002

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:

Add the entries below to postgresql.conf (* means listen on all adapters for a connection):
```
listen_addresses = *
port = 27500
```
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
```
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
```

Restart Postgres for the setting to take effect.

$pg_ctl restart -D instance_destination_directory

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

How do I configure Fujitsu Enterprise Postgres to use the pg_stat_statements extension?KB8003

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:

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'
```

Restart the instance.

pg_ctl restart -D instance_destination_directory

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

The error message lock file "postmaster.pid" already exists is displayed when I start the database.KB8004

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

The error message could not bind x socket: y is displayed when I start the database.KB8005

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

The error message unrecognized configuration parameter "x" in file "y" line z is displayed when I start the database using the pg_ctl command.KB8006

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

Why is the database slow to start up, and does not appear to complete?KB8007

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.

For more information about stopping Fujitsu Enterprise Postgres, refer to PostgreSQL documentation > Part III - Server administration > 18 - Server setup and operation > 18.5 - Shutting down the server

For more information about max_wal_size and checkpoint_timeout, refer to PostgreSQL documentation > Part III - Server administration > 19 - Server configuration > 19.5 - Write ahead log > 19.5.2 - Checkpoints

Applicable to

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

Versions: from 9.4

Architecture: X86, S390x

Operating System: Linux, Windows

How to confirm whether installation of Fujitsu Enterprise Postgres was succeeded on the Windows server?KB8008

Follow the steps below:

In Windows, select All Programs or All Apps > Fujitsu > Uninstall (middleware).
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

How to start the Fujitsu Enterprise Postgres server using server commands on the Windows server?KB8009

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

Step 1: Prerequisites

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.
Create the directories below:
- Data storage destination (required)
  Example: C:\work\database
- Transaction log storage destination (optional)
  Example: C:\work\transaction

For more information, refer to Fujitsu Enterprise Postgres Installation and Setup Guide for Server > Chapter 4 - Setup > 4.2 - Preparations for setup [Windows version]

Step 2: Create an instance using initdb

Open the command prompt as the instance administrator created earlier.

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%

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

If successful, the message below is output.

Success. You can now start the database server using:

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 3: Start the database server

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

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

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

How do I set up Grafana on IBM LinuxONE™?KB8010

How do I install the Prometheus adapter?KB8011

How do I install PostGIS?KB8012

Fujitsu Knowledge Base

Knowledge articles
Installation/Setup