Login | Register For Free | Help
Search for: (Advanced)

Mailing List Archive: Linux-HA: Users

Heartbeat & Postgresql

 

 

Linux-HA users RSS feed   Index | Next | Previous | View Threaded


btrocme at generalservices

Aug 21, 2009, 7:43 AM

Post #1 of 4 (1077 views)
Permalink
Heartbeat & Postgresql

Hello all,

I have problems with Postgresql & Heartbeat.
Heartbeat stop the postgresql service but he don't start...
My config' are :
- HDtest-01 (primary - 192.168.3.165) and HDtest-02 (secondary - 192.168.3.166)
- Drdb 0.8.14
- Heartbeat 2
- Debian 5

/etc/drbd.conf

resource documentis {
protocol C;


startup {
wfc-timeout 240;
degr-wfc-timeout 240;
}
disk {
on-io-error detach;
}
syncer {
al-extents 257;
}
on HDtest-01 {
device /dev/drbd0;
disk /dev/hda5;
address 192.168.3.165:7789;
meta-disk internal;
}
on HDtest-02 {
device /dev/drbd0;
disk /dev/hda5;
address 192.168.3.166:7789;
meta-disk internal;
}
}

/etc/heartbeat/ha.cf
logfacility local0
keepalive 2
deadtime 10
warntime 6
initdead 60
udpport 694
bcast eth0
auto_failback on
node HDtest-01
node HDtest-02

/etc/heartbeat/haresources

HDtest-01 drbddisk::documentis Filesystem::/dev/drbd0::/raid_ip::ext3 samba IPaddr::192.168.3.164 apache2 postgresql-8.4

/var/log/messages when Heartbeat restart in primary server :

Aug 21 15:59:18 HDtest-01 ResourceManager[2936]: info: Releasing resource group: hdtest-01 drbddisk::documentis Filesystem::/dev/drbd0::/raid_ip::ext3 samba IPaddr::192.168.3.164 apache2 postgresql-8.4
Aug 21 15:59:18 HDtest-01 ResourceManager[2936]: info: Running /etc/init.d/postgresql-8.4 stop
Aug 21 15:59:19 HDtest-01 ResourceManager[2936]: info: Running /etc/init.d/apache2 stop
Aug 21 15:59:20 HDtest-01 ResourceManager[2936]: info: Running /etc/ha.d/resource.d/IPaddr 192.168.3.164 stop
Aug 21 15:59:21 HDtest-01 ResourceManager[2936]: info: Running /etc/init.d/samba stop
Aug 21 15:59:23 HDtest-01 ResourceManager[2936]: info: Running /etc/ha.d/resource.d/Filesystem /dev/drbd0 /raid_ip ext3 stop
Aug 21 15:59:27 HDtest-01 ResourceManager[2936]: info: Running /etc/ha.d/resource.d/drbddisk documentis stop
Aug 21 16:04:56 HDtest-01 ResourceManager[3708]: info: Acquiring resource group: hdtest-01 drbddisk::documentis Filesystem::/dev/drbd0::/raid_ip::ext3 samba IPaddr::192.168.3.164 apache2 postgresql-8.4
Aug 21 16:04:56 HDtest-01 ResourceManager[3708]: info: Running /etc/ha.d/resource.d/drbddisk documentis start
Aug 21 16:04:56 HDtest-01 ResourceManager[3708]: info: Running /etc/ha.d/resource.d/Filesystem /dev/drbd0 /raid_ip ext3 start
Aug 21 16:04:56 HDtest-01 ResourceManager[3708]: info: Running /etc/init.d/samba start
Aug 21 16:04:57 HDtest-01 ResourceManager[3708]: info: Running /etc/ha.d/resource.d/IPaddr 192.168.3.164 start
Aug 21 16:04:57 HDtest-01 ResourceManager[3708]: info: Running /etc/init.d/apache2 start

I see postgresql, apache2 and samba stop and it's normal. I see apache2 and samba start but postgresql don't start and i have no error in this log
( http://192.168.3.164 and smb://192.168.3.164/raid_ip walk correctly)

Thanks,

Baptiste


_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems


sergeyfd at gmail

Aug 21, 2009, 7:51 AM

Post #2 of 4 (1018 views)
Permalink
Re: Heartbeat & Postgresql [In reply to]

Stop using Heartbeat v1. and start using Pacemaker (a.k.a Heartbeat v2.)

On Fri, Aug 21, 2009 at 8:43 AM, <btrocme [at] generalservices> wrote:
> Hello all,
>
> I have problems with Postgresql & Heartbeat.
> Heartbeat stop the postgresql service but he don't start...
> My config' are :
> - HDtest-01 (primary - 192.168.3.165) and HDtest-02 (secondary - 192.168.3.166)
> - Drdb 0.8.14
> - Heartbeat 2
> - Debian 5
>
> /etc/drbd.conf
>
> resource documentis {
>        protocol C;
>
>
>        startup {
>                wfc-timeout 240;
>                degr-wfc-timeout 240;
>        }
>        disk {
>                on-io-error detach;
>        }
>        syncer {
>                al-extents 257;
>        }
>        on HDtest-01 {
>                device /dev/drbd0;
>                disk /dev/hda5;
>                address 192.168.3.165:7789;
>                meta-disk internal;
>        }
>        on HDtest-02 {
>                device /dev/drbd0;
>                disk /dev/hda5;
>                address 192.168.3.166:7789;
>                meta-disk internal;
>        }
> }
>
> /etc/heartbeat/ha.cf
> logfacility local0
> keepalive 2
> deadtime 10
> warntime 6
> initdead 60
> udpport 694
> bcast eth0
> auto_failback on
> node HDtest-01
> node HDtest-02
>
> /etc/heartbeat/haresources
>
> HDtest-01 drbddisk::documentis Filesystem::/dev/drbd0::/raid_ip::ext3 samba IPaddr::192.168.3.164 apache2 postgresql-8.4
>
> /var/log/messages when Heartbeat restart in primary server :
>
> Aug 21 15:59:18 HDtest-01 ResourceManager[2936]: info: Releasing resource group: hdtest-01 drbddisk::documentis Filesystem::/dev/drbd0::/raid_ip::ext3 samba IPaddr::192.168.3.164 apache2 postgresql-8.4
> Aug 21 15:59:18 HDtest-01 ResourceManager[2936]: info: Running /etc/init.d/postgresql-8.4  stop
> Aug 21 15:59:19 HDtest-01 ResourceManager[2936]: info: Running /etc/init.d/apache2  stop
> Aug 21 15:59:20 HDtest-01 ResourceManager[2936]: info: Running /etc/ha.d/resource.d/IPaddr 192.168.3.164 stop
> Aug 21 15:59:21 HDtest-01 ResourceManager[2936]: info: Running /etc/init.d/samba  stop
> Aug 21 15:59:23 HDtest-01 ResourceManager[2936]: info: Running /etc/ha.d/resource.d/Filesystem /dev/drbd0 /raid_ip ext3 stop
> Aug 21 15:59:27 HDtest-01 ResourceManager[2936]: info: Running /etc/ha.d/resource.d/drbddisk documentis stop
> Aug 21 16:04:56 HDtest-01 ResourceManager[3708]: info: Acquiring resource group: hdtest-01 drbddisk::documentis Filesystem::/dev/drbd0::/raid_ip::ext3 samba IPaddr::192.168.3.164 apache2 postgresql-8.4
> Aug 21 16:04:56 HDtest-01 ResourceManager[3708]: info: Running /etc/ha.d/resource.d/drbddisk documentis start
> Aug 21 16:04:56 HDtest-01 ResourceManager[3708]: info: Running /etc/ha.d/resource.d/Filesystem /dev/drbd0 /raid_ip ext3 start
> Aug 21 16:04:56 HDtest-01 ResourceManager[3708]: info: Running /etc/init.d/samba  start
> Aug 21 16:04:57 HDtest-01 ResourceManager[3708]: info: Running /etc/ha.d/resource.d/IPaddr 192.168.3.164 start
> Aug 21 16:04:57 HDtest-01 ResourceManager[3708]: info: Running /etc/init.d/apache2  start
>
> I see postgresql, apache2 and samba stop and it's normal. I see apache2 and samba start but postgresql don't start and i have no error in this log
> ( http://192.168.3.164 and smb://192.168.3.164/raid_ip walk correctly)
>
> Thanks,
>
> Baptiste
>
>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
>



--
Serge Dubrouski.
_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems


btrocme at generalservices

Aug 24, 2009, 12:50 AM

Post #3 of 4 (1010 views)
Permalink
Re: Heartbeat & Postgresql [In reply to]

Same problem with Heartbeat 2...




_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems


sergeyfd at gmail

Aug 24, 2009, 7:22 AM

Post #4 of 4 (1004 views)
Permalink
Re: Heartbeat & Postgresql [In reply to]

Post your configuration.

On Mon, Aug 24, 2009 at 1:50 AM, <btrocme [at] generalservices> wrote:
> Same problem with Heartbeat 2...
>
>
>
>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA [at] lists
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
>



--
Serge Dubrouski.
_______________________________________________
Linux-HA mailing list
Linux-HA [at] lists
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems

Linux-HA users RSS feed   Index | Next | Previous | View Threaded
 
 


Interested in having your list archived? Contact Gossamer Threads
 
  Web Applications & Managed Hosting Powered by Gossamer Threads Inc.