Re: [Linux-HA] heartbeat with postgresql

2010-10-27 Thread Serge Dubrouski
On Wed, Oct 27, 2010 at 4:41 AM, Lars Ellenberg wrote: > On Tue, Oct 19, 2010 at 11:04:10AM -0600, Serge Dubrouski wrote: >> I see you could do it and now you are going to use Pacemaker "all the >> time in the future". Than I see no reason why other can't do it as >> well taking into account that

Re: [Linux-HA] heartbeat with postgresql

2010-10-27 Thread Lars Ellenberg
On Tue, Oct 19, 2010 at 12:11:03PM +0800, Linux Cook wrote: > hi! > > I used the tarball package of postgresql and recompiled it. Postgres now > resides at /usr/local/pgsql and mounting /usr/local/pgsql/data into > /dev/drbd0. > > However, hearbeat recognizes my Filesystem and IPaddr2 resources b

Re: [Linux-HA] heartbeat with postgresql

2010-10-27 Thread Lars Ellenberg
On Tue, Oct 19, 2010 at 11:04:10AM -0600, Serge Dubrouski wrote: > I see you could do it and now you are going to use Pacemaker "all the > time in the future". Than I see no reason why other can't do it as > well taking into account that Heartbeat v1 almost not supported and > definitely has no fut

Re: [Linux-HA] heartbeat with postgresql

2010-10-23 Thread Andrew Beekhof
On Fri, Oct 22, 2010 at 7:32 PM, Greg Woods wrote: > On Fri, 2010-10-22 at 18:32 +0200, Andrew Beekhof wrote: >> if you're just using v1 - thats not a cluster, >> thats a prayer. > > Then God must answer my prayers, because I have been using some simple > heartbeat v1/DRBD clusters for YEARS, for

Re: [Linux-HA] heartbeat with postgresql

2010-10-23 Thread Andrew Beekhof
On Fri, Oct 22, 2010 at 7:23 PM, Dimitri Maziuk wrote: > Andrew Beekhof wrote: > > OK, I'll post this and shut up. > >> Or are you really trying to claim that: >> >>    linuxha1 IPaddr::192.168.85.3 httpd smb >> >> is fundamentally less complex than >> >>    primitive IP ocf:heartbeat:IPaddr param

Re: [Linux-HA] heartbeat with postgresql

2010-10-22 Thread Greg Woods
On Fri, 2010-10-22 at 18:32 +0200, Andrew Beekhof wrote: > if you're just using v1 - thats not a cluster, > thats a prayer. Then God must answer my prayers, because I have been using some simple heartbeat v1/DRBD clusters for YEARS, for critical services like DNS. They have worked flawlessly and a

Re: [Linux-HA] heartbeat with postgresql

2010-10-22 Thread Dimitri Maziuk
Andrew Beekhof wrote: OK, I'll post this and shut up. > Or are you really trying to claim that: > >linuxha1 IPaddr::192.168.85.3 httpd smb > > is fundamentally less complex than > >primitive IP ocf:heartbeat:IPaddr params ip="192.168.85.3" >primitive http lsb:httpd >primitive s

Re: [Linux-HA] heartbeat with postgresql

2010-10-22 Thread Andrew Beekhof
On Wed, Oct 20, 2010 at 7:09 PM, Greg Woods wrote: > On Wed, 2010-10-20 at 08:13 +0200, Andrew Beekhof wrote: > >> > Um, maybe because heartbeat v1 has a much much much much less steep >> > learning curve? >> >> I dispute that: >> >>     >> http://theclusterguy.clusterlabs.org/post/178680309/confi

Re: [Linux-HA] heartbeat with postgresql

2010-10-22 Thread Andrew Beekhof
On Wed, Oct 20, 2010 at 4:43 PM, Dimitri Maziuk wrote: > Andrew Beekhof wrote: >> On Tue, Oct 19, 2010 at 6:44 PM, Greg Woods wrote: >>> On Tue, 2010-10-19 at 10:01 -0600, Serge Dubrouski wrote: Any particular reason for using Heartbeat v1 instead of CRM/Pacemaker? >>> Um, maybe because hear

Re: [Linux-HA] heartbeat with postgresql

2010-10-20 Thread Serge Dubrouski
On Wed, Oct 20, 2010 at 11:09 AM, Greg Woods wrote: > On Wed, 2010-10-20 at 08:13 +0200, Andrew Beekhof wrote: > >> > Um, maybe because heartbeat v1 has a much much much much less steep >> > learning curve? >> >> I dispute that: >> >>     >> http://theclusterguy.clusterlabs.org/post/178680309/conf

Re: [Linux-HA] heartbeat with postgresql

2010-10-20 Thread Greg Woods
On Wed, 2010-10-20 at 08:13 +0200, Andrew Beekhof wrote: > > Um, maybe because heartbeat v1 has a much much much much less steep > > learning curve? > > I dispute that: > > > http://theclusterguy.clusterlabs.org/post/178680309/configuring-heartbeat-v1-was-so-simple This addresses the fact

Re: [Linux-HA] heartbeat with postgresql

2010-10-20 Thread Dimitri Maziuk
Andrew Beekhof wrote: > On Tue, Oct 19, 2010 at 6:44 PM, Greg Woods wrote: >> On Tue, 2010-10-19 at 10:01 -0600, Serge Dubrouski wrote: >>> Any particular reason for using Heartbeat v1 instead of CRM/Pacemaker? >> Um, maybe because heartbeat v1 has a much much much much less steep >> learning curv

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Andrew Beekhof
On Tue, Oct 19, 2010 at 6:44 PM, Greg Woods wrote: > On Tue, 2010-10-19 at 10:01 -0600, Serge Dubrouski wrote: >> Any particular reason for using Heartbeat v1 instead of CRM/Pacemaker? > > Um, maybe because heartbeat v1 has a much much much much less steep > learning curve? I dispute that: h

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Dimitri Maziuk
Serge Dubrouski wrote: > > He's not using OCF. And that was the reason for my first question. Right. Someone else mentioned ocf pgsql primitive. In v1 case, /etc/init.d/postgresql -- recompiling from tarball typically doesn't install /etc/init.d/ scripts, or installs the wrong one (e.g. paths

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Serge Dubrouski
On Tue, Oct 19, 2010 at 2:00 PM, Dimitri Maziuk wrote: > Serge Dubrouski wrote: >> On Tue, Oct 19, 2010 at 1:49 PM, Dimitri Maziuk >> wrote: >> >>> The easiest fix was to create /drbdfs/pgsql with proper ownership and >>> symlink /var/lib/pgsql to it. Now that he's recompiled everything, who >>>

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Dimitri Maziuk
Serge Dubrouski wrote: > On Tue, Oct 19, 2010 at 1:49 PM, Dimitri Maziuk wrote: > >> The easiest fix was to create /drbdfs/pgsql with proper ownership and >> symlink /var/lib/pgsql to it. Now that he's recompiled everything, who >> knows. > > Or manually mount /var/lib/pgsql/data and fix ownershi

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Serge Dubrouski
On Tue, Oct 19, 2010 at 1:49 PM, Dimitri Maziuk wrote: > Serge Dubrouski wrote: > >> Ok. Please let's stop this useless holywar and try to help to solve >> the original problem: why PostgreSQL doesn't want to start on >> Heartbeat v1. I personally have no idea since I've never used >> Heartbeat v1

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Dimitri Maziuk
Serge Dubrouski wrote: > Ok. Please let's stop this useless holywar and try to help to solve > the original problem: why PostgreSQL doesn't want to start on > Heartbeat v1. I personally have no idea since I've never used > Heartbeat v1 and not going to. OP's problem has nothing to with heartbeat

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Serge Dubrouski
On Tue, Oct 19, 2010 at 12:41 PM, Dimitri Maziuk wrote: > Serge Dubrouski wrote: > >> I see you could do it and now you are going to use Pacemaker "all the >> time in the future". Than I see no reason why other can't do it as >> well taking into account that Heartbeat v1 almost not supported and >

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Dimitri Maziuk
Serge Dubrouski wrote: > I see you could do it and now you are going to use Pacemaker "all the > time in the future". Than I see no reason why other can't do it as > well taking into account that Heartbeat v1 almost not supported and > definitely has no future unless somebody will decide to fork i

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Serge Dubrouski
On Tue, Oct 19, 2010 at 10:44 AM, Greg Woods wrote: > On Tue, 2010-10-19 at 10:01 -0600, Serge Dubrouski wrote: >> Any particular reason for using Heartbeat v1 instead of CRM/Pacemaker? > > Um, maybe because heartbeat v1 has a much much much much less steep > learning curve? If you have a simple t

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Greg Woods
On Tue, 2010-10-19 at 10:01 -0600, Serge Dubrouski wrote: > Any particular reason for using Heartbeat v1 instead of CRM/Pacemaker? Um, maybe because heartbeat v1 has a much much much much less steep learning curve? If you have a simple two-node cluster where one node is just a hot spare, it is way

Re: [Linux-HA] heartbeat with postgresql

2010-10-19 Thread Serge Dubrouski
Any particular reason for using Heartbeat v1 instead of CRM/Pacemaker? On Mon, Oct 18, 2010 at 10:11 PM, Linux Cook wrote: > hi! > > I used the tarball package of postgresql and recompiled it. Postgres now > resides at /usr/local/pgsql and mounting /usr/local/pgsql/data into > /dev/drbd0. > > How

Re: [Linux-HA] heartbeat with postgresql

2010-10-18 Thread Linux Cook
hi! I used the tarball package of postgresql and recompiled it. Postgres now resides at /usr/local/pgsql and mounting /usr/local/pgsql/data into /dev/drbd0. However, hearbeat recognizes my Filesystem and IPaddr2 resources but not my postgresql service. My haresources config below: dmcstest1 drbd

Re: [Linux-HA] heartbeat with postgresql

2010-10-15 Thread Linux Cook
thanks michael and vadym, Will try your suggestions and will let you know. On Fri, Oct 15, 2010 at 4:46 AM, Vadym Chepkov wrote: > > On Oct 15, 2010, at 3:28 AM, Linux Cook wrote: > > > hi! > > > > I've just setup heartbeat + drbd with postgresql. I'm mirroring > /dev/drbd0 > > to /var/lib/post

Re: [Linux-HA] heartbeat with postgresql

2010-10-15 Thread Vadym Chepkov
On Oct 15, 2010, at 3:28 AM, Linux Cook wrote: > hi! > > I've just setup heartbeat + drbd with postgresql. I'm mirroring /dev/drbd0 > to /var/lib/postgresql. The problem is, postgresql service can't start > because everytime heartbeat mounts the /dev/drbd0 to /var/lib/postgresql, it > changes it

Re: [Linux-HA] heartbeat with postgresql

2010-10-15 Thread Michael Schwartzkopff
On Friday 15 October 2010 09:28:36 Linux Cook wrote: > hi! > > I've just setup heartbeat + drbd with postgresql. I'm mirroring /dev/drbd0 > to /var/lib/postgresql. The problem is, postgresql service can't start > because everytime heartbeat mounts the /dev/drbd0 to /var/lib/postgresql, > it change

[Linux-HA] heartbeat with postgresql

2010-10-15 Thread Linux Cook
hi! I've just setup heartbeat + drbd with postgresql. I'm mirroring /dev/drbd0 to /var/lib/postgresql. The problem is, postgresql service can't start because everytime heartbeat mounts the /dev/drbd0 to /var/lib/postgresql, it changes it user and group ownership instead of just postgres user and g