[Linux-HA] heartbeat with postgresql

Serge Dubrouski sergeyfd at gmail.com
Tue Oct 19 10:01:20 MDT 2010


Any particular reason for using Heartbeat v1 instead of CRM/Pacemaker?

On Mon, Oct 18, 2010 at 10:11 PM, Linux Cook <linuxcook at gmail.com> 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 but not my
> postgresql service. My haresources config below:
>
> dmcstest1 drbddisk::postgres
> Filesystem::/dev/drbd0::/usr/local/pgsql/data::ext3 IPaddr2::
> 10.110.10.250/255.255.255.0/eth2
> dmcstest1 postgresql
>
> I've seen an error like:
>
> "resource postgreql is active and should not be" on the logs but postgresql
> is disabled on bootup. What does this mean?
>
> Please help!
>
> Thank you.
>
> Oliver
>
> On Sat, Oct 16, 2010 at 2:41 AM, Linux Cook <linuxcook at gmail.com> wrote:
>
>> thanks michael and vadym,
>>
>> Will try your suggestions and will let you know.
>>
>> On Fri, Oct 15, 2010 at 4:46 AM, Vadym Chepkov <vchepkov at gmail.com> 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/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
>>> group.
>>> >
>>>
>>> I wouldn't recommend using /var/lib/postgres as a mount point.
>>> on rpm based systems you would probably break package integrity and
>>> I don't think it's safe to have a non-root user to be owner of the mount
>>> point
>>> Just create a new directory, '/pgsql', for example, and use it, instead.
>>>
>>> primitive pgsql ocf:heartbeat:pgsql \
>>>        params pgdba="postgres" pgdata="/pgsql/data"
>>> logfile="/pgsql/log/pgsql.log" \
>>>        op monitor start-delay="60s" interval="5min"
>>>
>>> Vadym
>>
>>
>>
> _______________________________________________
> Linux-HA mailing list
> Linux-HA at lists.linux-ha.org
> http://lists.linux-ha.org/mailman/listinfo/linux-ha
> See also: http://linux-ha.org/ReportingProblems
>



-- 
Serge Dubrouski.



More information about the Linux-HA mailing list