PostgreSQL resource agent has wrong default paths
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
resource-agents (Ubuntu) |
Invalid
|
Undecided
|
Unassigned | ||
Precise |
Expired
|
Undecided
|
Unassigned |
Bug Description
The pgsql resource agent has default paths which don't match those used by the Ubuntu postgresql package
In the resource agent:
* The default configuration file is /etc/postgresql
* The default loction of pg_ctl is /usr/lib/
* The default data directory is given as /var/lib/pgsql/data
This causes Pacemaker to be unable to start the postgresql server, and the following errors in /var/log/syslog:
Mar 14 14:51:38 OB1 pgsql[3533]: ERROR: Configuration file /var/lib/
Mar 14 14:51:38 OB1 pgsql[3533]: ERROR: Setup problem: couldn't find command: /usr/bin/pg_ctl
The problem is in the file /usr/lib/
The following patch fixes these problems:
=======
--- pgsql.old 2012-03-14 15:17:09.123507205 +0000
+++ pgsql 2012-03-14 15:19:37.521641615 +0000
@@ -45,13 +45,13 @@
}
# Defaults
-OCF_RESKEY_
+OCF_RESKEY_
OCF_RESKEY_
-OCF_RESKEY_
+OCF_RESKEY_
OCF_RESKEY_
OCF_RESKEY_
OCF_RESKEY_
-OCF_RESKEY_
+OCF_RESKEY_
OCF_RESKEY_
OCF_RESKEY_
OCF_RESKEY_
=======
Status changed to 'Confirmed' because the bug affects multiple users.