The table below lists and explains names and meanings of the PostgreSQL parameters. These values are tuned by editing the /etc/default/LifeKeeper configuration file.

Parameter Name Meaning Setting Value Default Value When to Apply Notes
LKPGSQL_KILLPID_TIME Time in seconds to wait after a process id is killed before rechecking for this process. Integers 3 As required (takes effect immediately) If the value is less than the default, it will be set to the default.
LKPGSQL_CONN_RETRIES Replaces LKPGSQLMAXCOUNT – number of times to try a client connection after an action (start or stop). Integers 12 As required (takes effect immediately) If the value is less than the default, it will be set to the default.
LKPGSQL_ACTION_RETRIES Number of times to attempt start or stop action before failing the action command. Integers 4 As required (takes effect immediately) If the value is less than the default, it will be set to the default.
LKPGSQL_STATUS_TIME Timeout in seconds for the status command. Integers 17 + (3 * LKPGSQL_KILLPID_TIME) As required (takes effect immediately) If the value is less than the default, it will be set to the default.
LKPGSQL_QCKHANG_MAX Number of quickCheck script hangs allowed before a failover/sendevent is triggered for the database instance. Integers 2 Creating a resource If the value is less than 1, it will be set to the default.
LKPGSQL_CUSTOM_DAEMON Allows a user to specify additional aliases for the postgres daemons (postgres.bin,postmaster,postgres,edb-postgres). String (not set) Creating a resource
LKPGSQL_IDIRS Replaces LKPGSQL_IPORTS – contains datadir entries for instances that will be shutdown using the immediate option only. String (not set) As required (takes effect immediately)
LKPGSQL_SDIRS Contains datadir entries for instances that will be shutdown using the smart option. String (not set) As required (takes effect immediately)
LKPGSQL_DISCONNECT_CLIENT Controls whether active clients will be disconnected in the event of a postmaster crash. When the value is set to 1, 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. 0: enabled

1: disabled
1 As required (takes effect immediately) 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. String (not set) As required (takes effect immediately) This parameter cannot be used for PostgreSQL 8.2 and later.
LKPGSQL_RESUME_PROC Determines if a process found in the stopped state (state = ~T) will be resumed when detected or ignored. 0:ignore

1:resume
1 As required (takes effect immediately)
LKPGSQLDEBUG Turns on debug for PostgreSQL database kit as well as for the postgres database. Valid entry range: 0 – 5.

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

Integers (0 – 5) 0 As required (takes effect immediately) If a value is not within the allowable range, it will be set to the default.

Feedback

Thanks for your feedback.

Post your comment on this topic.

Post Comment