Top
Enterprise Postgres 17 Cluster Operation Guide(Database Multiplexing)

Appendix G Collecting Failure Investigation Data

If the cause of an error that occurs while building the environment or during operations is unclear, data must be collected for initial investigation.

This appendix describes how to collect data for initial investigation.

Using a database server to collect data
Using an arbitration server to collect data

See

  • Linux

    • Refer to the FJQSS manual for information on how to use FJQSS.

    • Refer to "pgx_fjqssinf" in the Reference for informations about the pgx_fjqssinf command.

  • Windows

    • Refer to the following manual for information on how to use FJQSS.

      • In the [Apps] menu, select [FJQSS (Information Collection Tool)], and then click [FJQSS User's Guide].

    • Refer to "pgx_fjqssinf" in the Reference for informations about the pgx_fjqssinf.bat command.

Note

Using a database server to collect data
  • When using FJQSS to collect data for initial investigation, you must set the following environment variables:

    • Environment variable required for collecting data from the database

      Refer to "Collecting Failure Investigation Data" in the Operation Guide.

    • MCCONTROLDIR

      Set the Mirroring Controller management directory.
      Refer to "1.2.1 Mirroring Controller Resources" for information on the Mirroring Controller management directory.

Using an arbitration server to collect data
Linux
  • When using FJQSS to collect data for initial investigation, you must set the following environment variables:

    • ARBCONTROLDIR

      Set the Mirroring Controller arbitration process management directory.
      Refer to "1.2.1 Mirroring Controller Resources" for information on the Mirroring Controller arbitration server management directory.

    • ARBUSER

      Specify the operating system user who started the Mirroring Controller arbitration process.

    • FSEP_SA_HOME

      Set the Server Assistant installation directory.

Windows
  • When using FJQSS to collect data for initial investigation, a window will be displayed for you to set the following environment variables. When using the pgx_fjqssinf.bat command, set the following environment variables in advance:

    • ARBCONTROLDIR

      Set the Mirroring Controller arbitration process management directory.
      Refer to "1.2.1 Mirroring Controller Resources" for information on the Mirroring Controller arbitration server management directory.