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
> > [email protected]
> > http://lists.linux-ha.org/mailman/listinfo/linux-ha
> > See also: http://linux-ha.org/ReportingProblems
> >
>
>
>
> --
> Serge Dubrouski.
> _______________________________________________
> Linux-HA mailing list
> [email protected]
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
> _______________________________________________
> Linux-HA mailing list
> [email protected]
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
>
--
Serge Dubrouski.
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems
