SIOS TECHNOLOGY CORP.

PostgreSQL Tunables

Error Solution
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.

Note: This parameter cannot be used for PostgreSQL 8.2 and later.
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.

Note: This parameter cannot be used for PostgreSQL 8.2 and later.
LKPGSQL_RESUME_PROC Determines if process found in the stopped state (state = ~T) will be resumed when detected or ignored.
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>.

Feedback

Was this helpful?

Yes No
You indicated this topic was not helpful to you ...
Could you please leave a comment telling us why? Thank you!
Thanks for your feedback.

Post your comment on this topic.

Post Comment