[Linux-ha-dev] [PATCH] pgsql resource improvement

[Keisuke MORI]

Hi,

The attachment is a patch for pgsql.in to fix an annoying
problem and some typos.

* Problem:

Pgsql fails to launch PostgreSQL unobviously even if it's
configured properly.

The cause is that PostgreSQL log file /var/log/pgsql.log, which
is hard-coded in the script, is not usually writable to PGDBA
user (at least on RedHat EL4), and pgsql just returns with no
obvious log messages when it failed to create the log file, so
users will be puzzled why it failed.

* Solution:

This patch fixes it as follows, and also fixes some typos:

 - make the log file path configurable as an OCF parameter
   "logfile" in cib.xml.

 - try to create the log file with PGDBA user and leave an error
   log message if it failed.

 - default logfile path is now /dev/null. I made it so because
   1) an appropriate path largely depends on distros' or an
   user's policy and 2) the default of PostgreSQL init.d script
   which comes with RedHat is also /dev/null.  


The patch is against 2.0.7.
I would appreciate if it is incorporated into the future release.

Sincerely,

Keisuke MORI
NTT DATA Intellilink Corporation
-------------- next part --------------
A non-text attachment was scrubbed...
Name: heartbeat-2.0.7-pgsql.patch
Type: text/x-patch
Size: 2931 bytes
Desc: not available
Url : http://lists.community.tummy.com/pipermail/linux-ha-dev/attachments/20060815/704e01c6/heartbeat-2.0.7-pgsql.bin