Knowledge articles
Client tools

This may be happening because the password to connect to the database server has not been preset, so you are being prompted to enter it and the psql command is waiting.

Resolution

Preconfigure the password to connect to the database server by doing one of the following:

• Specify the password in the PGPASSWORD environment variable.

  For details, refer to PostgreSQL documentation > Part IV - Client interfaces > Chapter 33 - libpq-C library > 33.15 - The password file.

• Specify the password file.
  • Linux/Solaris

    Create the .pgpass file in the home directory of the executing user and specify the password

  • Windows

    Create the %APPDATA%\postgresql\pgpass.conf file and specify the password (where % APPDATA% refers to the Application Data directory in the user's profile).

  For details, refer to:

  • PostgreSQL documentation > Part IV - Client interfaces > Chapter 33 - libpq-C library > 33.15 - The password file
  • PostgreSQL documentation > Part III - Server administration > Chapter 20 - Client authentication
  • PostgreSQL documentation > Part VI. Reference > PostgreSQL client applications > psql

Applicable to

Product: Fujitsu Enterprise Postgres SE, Fujitsu Enterprise Postgres AE, PostgreSQL

Versions: from 9.5

Architecture: X86, S390x

Operating System: Windows, Linux

This may be happending because you applied an emergency fix for the WebAdmin feature (GUI features) and have not set up WebAdmin afterwards.

Please refer to the emergency fix information file [Notes] to run the WebAdmin setup.

For more information on WebAdmin setup, refer to Fujitsu Enterprise Postgres Installation and Setup Guide for Server > Appendix B - Setting up and removing WebAdmin > B.1 - Setting up WebAdmin > B.1.1 Setting up WebAdmin [Linux version] [Windows version].

Applicable to

Product: Fujitsu Enterprise Postgres SE, Fujitsu Enterprise Postgres AE

Versions: from 9.5

Architecture: X86, S390x

Operating System: Windows, Linux