Thank you for taking the time to report this bug. In an effort to keep an
up-to-date and valid list of bugs to work on, I have reviewed this report
to verify it still requires effort and occurs on an Ubuntu release in
standard support, and it does not.
It is unfortunate that we were unable to resolve this defect, however
there appears to be no further action possible at this time. I am
therefore moving the bug to 'Incomplete'. If you disagree or have
new information, we would be grateful if you could please add a comment
stating why and then change the status of the bug to 'New'.
Observation:
The correct affected package for this bug is resource-agents:
(k)rafaeldtinoco@clufocal01:~$ dpkg -L resource-agents | grep -i pgsql
/usr/lib/ocf/resource.d/heartbeat/pgsql
and I'm opening a generic bug to check ALL resource agents paths
existence.
** Also affects: resource-agents (Ubuntu)
Importance: Undecided
Status: New
** No longer affects: pacemaker (Ubuntu)
** Also affects: resource-agents (Ubuntu Precise)
Importance: Undecided
Status: New
** Changed in: resource-agents (Ubuntu Precise)
Status: New => Incomplete
** Changed in: resource-agents (Ubuntu)
Status: New => Invalid
--
You received this bug notification because you are a member of Ubuntu
High Availability Team, which is subscribed to pacemaker in Ubuntu.
https://bugs.launchpad.net/bugs/955164
Title:
PostgreSQL resource agent has wrong default paths
Status in resource-agents package in Ubuntu:
Invalid
Status in resource-agents source package in Precise:
Incomplete
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/9.1/main/postgresql.conf
* The default loction of pg_ctl is /usr/lib/postgresql/9.1/bin/pg_ctl
* 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/pgsql/data/postgresql.conf doesn't exist
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/ocf/resource.d/heartbeat/pgsql
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_pgctl_default=/usr/bin/pg_ctl
+OCF_RESKEY_pgctl_default=/usr/lib/postgresql/9.1/bin/pg_ctl
OCF_RESKEY_psql_default=/usr/bin/psql
-OCF_RESKEY_pgdata_default=/var/lib/pgsql/data
+OCF_RESKEY_pgdata_default=/var/lib/postgresql/9.1/main
OCF_RESKEY_pgdba_default=postgres
OCF_RESKEY_pghost_default=""
OCF_RESKEY_pgport_default=5432
-OCF_RESKEY_config_default=""
+OCF_RESKEY_config_default=/etc/postgresql/9.1/main/postgresql.conf
OCF_RESKEY_start_opt_default=""
OCF_RESKEY_pgdb_default=template1
OCF_RESKEY_logfile_default=/dev/null
=============================================================================
To manage notifications about this bug go to:
https://bugs.launchpad.net/ubuntu/+source/resource-agents/+bug/955164/+subscriptions
_______________________________________________
Mailing list: https://launchpad.net/~ubuntu-ha
Post to : ubuntu-ha@lists.launchpad.net
Unsubscribe : https://launchpad.net/~ubuntu-ha
More help : https://help.launchpad.net/ListHelp
