I think that something is wrong with your PostgreSQL installation, though I'm not sure. Can you start PostgreSQL manually? Can you connect to it?
Also I'm sorry to say that but the pgsql script was little bit changed after 2.1.3 release. So if you can please get a new one from http://hg.linux-ha.org/dev. Though default one should work too. On Thu, Feb 28, 2008 at 11:58 AM, Carlos Alexandre de Souza da Silva <[EMAIL PROTECTED]> wrote: > Thanks a lot for your feedback, I think I advanced a little bit but I > am still having some problems. > > My cib.xml and error log are posted below I am trying to do na > active/passive postgres conf. > > Any ideias ?? I am really desperate for help and this is my first > experience with heartbeat(I am finding it a little complex). > > <cib generated="true" admin_epoch="0" have_quorum="true" > ignore_dtd="false" ccm_transition="4" num_peers="2" > cib_feature_revision="2.0" > dc_uuid="34a67e55-71b1-421f-96cc-519ef05b110b" epoch="16" > num_updates="1" cib-last-written="Thu Feb 28 12:59:05 2008"> > <configuration> > <crm_config> > <cluster_property_set id="cib-bootstrap-options"> > <attributes> > <nvpair id="cib-bootstrap-options-dc-version" > name="dc-version" value="2.1.3-node: > 552305612591183b1628baa5bc6e903e0f1e26a3"/> > <nvpair name="last-lrm-refresh" > id="cib-bootstrap-options-last-lrm-refresh" value="1204214339"/> > </attributes> > </cluster_property_set> > </crm_config> > <nodes> > <node id="34a67e55-71b1-421f-96cc-519ef05b110b" > uname="pgslave.blumar.com.br" type="normal"/> > <node id="56ec2257-b0e1-4395-8ca2-ff2f96151b55" > uname="pgmaster.blumar.com.br" type="normal"/> > </nodes> > <resources> > <group id="group_pgsql"> > <meta_attributes id="group_pgsql_meta_attrs"> > <attributes> > <nvpair id="group_pgsql_metaattr_target_role" > name="target_role" value="stopped"/> > </attributes> > </meta_attributes> > <primitive id="resource_ip" class="ocf" type="IPaddr" > provider="heartbeat"> > <instance_attributes id="resource_ip_instance_attrs"> > <attributes> > <nvpair id="f294ba51-00f9-4a9b-80c0-43aa7944f474" > name="ip" value="10.3.3.24"/> > </attributes> > </instance_attributes> > <meta_attributes id="resource_ip_meta_attrs"> > <attributes> > <nvpair id="resource_ip_metaattr_target_role" > name="target_role" value="started"/> > </attributes> > </meta_attributes> > </primitive> > <primitive id="resource_pgsql" class="ocf" type="pgsql" > provider="heartbeat"> > <instance_attributes id="resource_pgsql_instance_attrs"> > <attributes> > <nvpair id="778d991a-6ee1-4ed8-8cd8-a9d2d781d594" > name="pgdata" value="/var/lib/pgsql/data"/> > </attributes> > </instance_attributes> > <meta_attributes id="resource_pgsql_meta_attrs"> > <attributes> > <nvpair id="resource_pgsql_metaattr_target_role" > name="target_role" value="started"/> > </attributes> > </meta_attributes> > </primitive> > </group> > </resources> > <constraints/> > </configuration> > </cib> > > > I am getting an error output when I start heartbeat: > > > Feb 28 12:59:03 pgmaster IPaddr[3344]: [3402]: INFO: eval ifconfig > eth1:0 10.3.3.24 netmask 255.255.254.0 broadcast 10.3.3.255 > Feb 28 12:59:04 pgmaster crmd: [2550]: info: process_lrm_event: LRM > operation resource_ip_start_0 (call=14, rc=0) complete > Feb 28 12:59:05 pgmaster crmd: [2550]: info: do_lrm_rsc_op: Performing > op=resource_pgsql_start_0 key=9:27:24306842-9302-494a-a8aa-7dfb21478f8d) > Feb 28 12:59:05 pgmaster lrmd: [2547]: info: rsc:resource_pgsql: start > Feb 28 12:59:05 pgmaster pgsql[3432]: [3467]: INFO: PostgreSQL start > command sent. > Feb 28 12:59:05 pgmaster pgsql[3432]: [3469]: INFO: PostgreSQL is down > Feb 28 12:59:05 pgmaster cib: [3471]: info: retrieveCib: Reading cluster > configuration from: /var/lib/heartbeat/crm/cib.xml (digest: > /var/lib/heartbeat/crm/cib.xml.sig) > Feb 28 12:59:05 pgmaster cib: [3471]: info: retrieveCib: Reading cluster > configuration from: /var/lib/heartbeat/crm/cib.xml (digest: > /var/lib/heartbeat/crm/cib.xml.sig) > Feb 28 12:59:05 pgmaster cib: [3471]: info: retrieveCib: Reading cluster > configuration from: /var/lib/heartbeat/crm/cib.xml.last (digest: > /var/lib/heartbeat/crm/cib.xml.sig.last) > Feb 28 12:59:05 pgmaster cib: [3471]: info: write_cib_contents: Wrote > version 0.16.1 of the CIB to disk (digest: > 3b8a668ff6f047872a103e00013874ce) > Feb 28 12:59:05 pgmaster cib: [3471]: info: retrieveCib: Reading cluster > configuration from: /var/lib/heartbeat/crm/cib.xml (digest: > /var/lib/heartbeat/crm/cib.xml.sig) > Feb 28 12:59:05 pgmaster cib: [3471]: info: retrieveCib: Reading cluster > configuration from: /var/lib/heartbeat/crm/cib.xml.last (digest: > /var/lib/heartbeat/crm/cib.xml.sig.last) > Feb 28 12:59:06 pgmaster pgsql[3432]: [3474]: INFO: PostgreSQL is down > Feb 28 12:59:07 pgmaster pgsql[3432]: [3478]: INFO: PostgreSQL is down > Feb 28 12:59:08 pgmaster pgsql[3432]: [3482]: INFO: PostgreSQL is down > Feb 28 12:59:09 pgmaster pgsql[3432]: [3486]: INFO: PostgreSQL is down > Feb 28 12:59:10 pgmaster pgsql[3432]: [3490]: INFO: PostgreSQL is down > Feb 28 12:59:11 pgmaster pgsql[3432]: [3494]: INFO: PostgreSQL is down > Feb 28 12:59:12 pgmaster pgsql[3432]: [3498]: INFO: PostgreSQL is down > Feb 28 12:59:13 pgmaster pgsql[3432]: [3502]: INFO: PostgreSQL is down > Feb 28 12:59:14 pgmaster pgsql[3432]: [3506]: INFO: PostgreSQL is down > Feb 28 12:59:15 pgmaster pgsql[3432]: [3510]: INFO: PostgreSQL is down > Feb 28 12:59:16 pgmaster pgsql[3432]: [3514]: INFO: PostgreSQL is down > Feb 28 12:59:17 pgmaster pgsql[3432]: [3518]: INFO: PostgreSQL is down > Feb 28 12:59:18 pgmaster pgsql[3432]: [3522]: INFO: PostgreSQL is down > Feb 28 12:59:19 pgmaster pgsql[3432]: [3526]: INFO: PostgreSQL is down > Feb 28 12:59:20 pgmaster pgsql[3432]: [3530]: INFO: PostgreSQL is down > Feb 28 12:59:21 pgmaster pgsql[3432]: [3534]: INFO: PostgreSQL is down > Feb 28 12:59:22 pgmaster pgsql[3432]: [3538]: INFO: PostgreSQL is down > > > -----Mensagem original----- > De: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] Em nome de Serge Dubrouski > Enviada em: quinta-feira, 28 de fevereiro de 2008 14:07 > > > Para: General Linux-HA mailing list > Assunto: Re: [Linux-HA] Problems Starting Postgres LSB-Compliant > > Using v2 without CRM doesn't get any real sense. > > The error that you are getting form OCF scrip is a right. If you wan't > to call it form command line you need to set OCF_ROOT variable to > /usr/lib/ocf. > > There are quite a few people using Heartbeat with CRM for controlling > PostgreSQL so it's not that hard as you think, so I'd recommend to > start using CRM. You can try GUI for building your cib.xml. > > On Thu, Feb 28, 2008 at 10:00 AM, Carlos Alexandre de Souza da Silva > <[EMAIL PROTECTED]> wrote: > > I am using v2 w/o CRM, the cib.xml looks kinda hard to configure. > > > > If I browse into OCF scripts directory and o a ./pgsql start I will > get > > ./pgsql: line 26: /resource.d/heartbeat/.ocf-shellfuncs: No such file > or > > directory > > > > This is just what I get from running it from command line, dont know > if > > this is supported anyway. The rpms that I got my heartbeat from were > the > > ones from centos 5 repo. > > > > -----Mensagem original----- > > De: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] Em nome de Serge > Dubrouski > > Enviada em: quinta-feira, 28 de fevereiro de 2008 13:51 > > Para: General Linux-HA mailing list > > Assunto: Re: [Linux-HA] Problems Starting Postgres LSB-Compliant > > > > > > > > Why you don't use an OCF script? > > > > On Thu, Feb 28, 2008 at 9:47 AM, Carlos Alexandre de Souza da Silva > > <[EMAIL PROTECTED]> wrote: > > > I am getting this errors, anyone knows how to fix this or get a > > > LSB-Compliant init script, I am using the postgres 8.2.6 for > redhat 5 > > > from postgresql.org > > > > > > > > > > > > Thanks in advance > > > > > > > > > > > > > > > > > > Feb 28 10:28:57 pgmaster ResourceManager[9259]: [9610]: ERROR: > Return > > > code 1 from /etc/init.d/postgresql > > > > > > Feb 28 10:28:58 pgmaster ResourceManager[9259]: [9613]: info: > > Retrying > > > failed stop operation [postgresql] > > > > > > Feb 28 10:28:58 pgmaster ResourceManager[9259]: [9622]: info: > Running > > > /etc/init.d/postgresql stop > > > > > > Feb 28 10:28:58 pgmaster ResourceManager[9259]: [9659]: ERROR: > Return > > > code 1 from /etc/init.d/postgresql > > > > > > Feb 28 10:28:59 pgmaster ResourceManager[9259]: [9662]: info: > > Retrying > > > failed stop operation [postgresql] > > > > > > Feb 28 10:28:59 pgmaster ResourceManager[9259]: [9671]: info: > Running > > > /etc/init.d/postgresql stop > > > > > > Feb 28 10:28:59 pgmaster ResourceManager[9259]: [9708]: ERROR: > Return > > > code 1 from /etc/init.d/postgresql > > > > > > Feb 28 10:29:00 pgmaster ResourceManager[9259]: [9711]: info: > > Retrying > > > failed stop operation [postgresql] > > > > > > Feb 28 10:29:00 pgmaster ResourceManager[9259]: [9720]: info: > Running > > > /etc/init.d/postgresql stop > > > > > > Feb 28 10:29:00 pgmaster ResourceManager[9259]: [9757]: ERROR: > Return > > > code 1 from /etc/init.d/postgresql > > > > > > Feb 28 10:29:01 pgmaster ResourceManager[9259]: [9760]: info: > > Retrying > > > failed stop operation [postgresql] > > > > > > Feb 28 10:29:01 pgmaster ResourceManager[9259]: [9769]: info: > Running > > > /etc/init.d/postgresql stop > > > > > > Feb 28 10:29:02 pgmaster ResourceManager[9259]: [9806]: ERROR: > Return > > > code 1 from /etc/init.d/postgresql > > > > > > Feb 28 10:29:03 pgmaster ResourceManager[9259]: [9809]: info: > > Retrying > > > failed stop operation [postgresql] > > > > > > Feb 28 10:29:03 pgmaster ResourceManager[9259]: [9818]: info: > Running > > > /etc/init.d/postgresql stop > > > > > > Feb 28 10:29:03 pgmaster ResourceManager[9259]: [9855]: ERROR: > Return > > > code 1 from /etc/init.d/postgresql > > > > > > Feb 28 10:29:04 pgmaster ResourceManager[9259]: [9858]: info: > > Retrying > > > failed stop operation [postgresql] > > > > > > Feb 28 10:29:04 pgmaster ResourceManager[9259]: [9867]: info: > Running > > > /etc/init.d/postgresql stop > > > > > > Feb 28 10:29:04 pgmaster ResourceManager[9259]: [9904]: ERROR: > Return > > > code 1 from /etc/init.d/postgresql > > > > > > Feb 28 10:29:04 pgmaster ResourceManager[9259]: [9926]: ERROR: > > Resource > > > script for postgresql probably not LSB-compliant. > > > > > > Feb 28 10:29:04 pgmaster ResourceManager[9259]: [9927]: WARN: it > > > (postgresql) MUST succeed on a stop when already stopped > > > > > > > > > > > > Carlos Alexandre > > > Analista de Suporte > > > > > > Direct Phone: + 55 21 2142-9383 > > > www.blumar.com.br <http://www.blumar.com.br> > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > > Av. Borges de Medeiros, 633 - Sala 405 a 408 - Leblon - Rio de > > janeiro - > > > Brasil - 22430-041 > > > www.blumar.com.br <http://www.blumar.com.br> phone: +55 21 2142 > 9300 > > > fax: +55 21 2511 3739 > > > > > > > > > > > > > > > > > > > > > _______________________________________________ > > > Linux-HA mailing list > > > Linux-HA@lists.linux-ha.org > > > http://lists.linux-ha.org/mailman/listinfo/linux-ha > > > See also: http://linux-ha.org/ReportingProblems > > > > > > > > > > > -- > > Serge Dubrouski. > > _______________________________________________ > > Linux-HA mailing list > > Linux-HA@lists.linux-ha.org > > http://lists.linux-ha.org/mailman/listinfo/linux-ha > > See also: http://linux-ha.org/ReportingProblems > > _______________________________________________ > > Linux-HA mailing list > > Linux-HA@lists.linux-ha.org > > http://lists.linux-ha.org/mailman/listinfo/linux-ha > > See also: http://linux-ha.org/ReportingProblems > > > > > > -- > Serge Dubrouski. > _______________________________________________ > Linux-HA mailing list > Linux-HA@lists.linux-ha.org > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems > _______________________________________________ > Linux-HA mailing list > Linux-HA@lists.linux-ha.org > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems > -- Serge Dubrouski. _______________________________________________ Linux-HA mailing list Linux-HA@lists.linux-ha.org http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
