The PostgreSQL Recovery Kit provides tunable environment variables to help customize resource protection in certain scenarios. To change the values of these variables, edit the file %LKROOT%\etc\default\LifeKeeper. No processes need to be restarted for the new settings to take effect. The default values will work for most environments where the PostgreSQL Recovery Kit will be installed.

• LKPGSQL_START_RETRIES

This tunable controls the number of times the PostgreSQL Recovery Kit will loop waiting for the database cluster to start before giving up with a failed status. There is a 5 second wait between each retry. By default the Recovery Kit will retry 12 times resulting is a 60 second wait for the database cluster to startup. The minimum value for this tunable setting is 12.

• LKPGSQL_STOP_RETRIES

This tunable controls the number of times the PostgreSQL Recovery Kit will loop waiting for the database cluster to stop before giving up with a failed status. There is a 5 second wait between each retry. By default the Recovery Kit will retry 12 times resulting is a 60 second wait for the database cluster to stop. The minimum value for this tunable setting is 12.

• LKPGSQL_RESTORE_CONNECT_RETRIES

This tunable controls the number of times during a restore action that the PostgreSQL Recovery Kit will loop waiting for the database cluster to respond to a connection request. If the number of retries is reached the restore action will be failed. There is a 5 second wait between each retry. By default the Recovery Kit will retry 2 times resulting is a 10 second wait for the database cluster to respond to the connection request. The minimum value for this tunable setting is 2.

Tunable Settings for the PostgreSQL Database Cluster

To check the health of the PostgreSQL database cluster, the Recovery Kit’s deepchk script will attempt to connect to the database cluster’s template1 db. This connection operation can fail if all the available connections are in use. This can be prevented via the PostgreSQL super user connection tunable.

• superuser_reserved_connections

This tunable in the database cluster postgresql.conf file controls the number of super user connections allowed. By default this setting is commented out. This setting should be uncommented. For the change to take effect, the PostgreSQL database cluster will need to be stopped and restarted.