You are here: Troubleshooting > Tunables

Tunables

 

Tunable

Function

LKPGSQL_KILLPID_TIME

Time to wait after a process id is killed before rechecking for this process.

LKPGSQL_CONN_RETRIES

Replaces LKPGSQLMAXCOUNT – number of times to try a client connection after an action (start or stop)

LKPGSQL_ACTION_RETRIES

Number of times to attempt start or stop action before failing the action command.

LKPGSQL_STATUS_TIME

Timeout for status command.

LKPGSQL_QCKHANG_MAX

Number of quickCheck script hangs allowed before a failover/sendevent is triggered for the database instance.

LKPGSQL_CUSTOM_DAEMON

Allows a user to specify additional aliases for the postgres daemons (default postmaster).

LKPGSQL_IDIRS

Replaces LKPGSQL_IPORTS – Contains datadir entries for instances that will be shutdown using the immediate option only.

LKPGSQL_SDIRS

Contains datadir entries for instances that will be shutdown using the smart option.

LKPGSQL_DISCONNECT_CLIENT

Controls the behavior the PostgreSQL resource hierarchy during a database failure scenario.  When the value is set to 1(true), client processes will be sent a SIGTERM signal to force them to disconnect from the database.  This action will only be taken if the postmaster process is not running during local recovery.

LKPGSQL_DISCONNECT CLIENT_BYTAG

Similar to LKPGSQL_DISCONNECT_CLIENT, this setting limits the action to the comma separated list of tags specified by this tunable.

LKPGSQL_RESUME_PROC

Determines if process found in the stopped state (state = ~T) will be resumed when detected or ignored.

LKPGSQL_CLIENT

Provides a hint for the name of the client utility psql.

LKPGSQL_UTIL

Provides a hint for the name of the administrative utilitypg_ctl.

LKPGSQLDEBUG

Turns on debug for PostgreSQL database kit as well as for the postgres database. Valid entry range: 0 – 5.  Larger numbers produce greater debug information.

This tunable will be passed on to the postmaster database using the option –d <LKPGSQLDEBUG>.

© 2012 SIOS Technology Corp., the industry's leading provider of business continuity solutions, data replication for continuous data protection.