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. |
Post your comment on this topic.