[Linux-HA] heartbeat with postgresql
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:
> I used the tarball package of postgresql and recompiled it. Postgres now
> resides at /usr/local/pgsql and mounting /usr/local/pgsql/data into
> 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::
> 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.
> 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
>>> > 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
>>> 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
>>> 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"
> Linux-HA mailing list
> Linux-HA at lists.linux-ha.org
> See also: http://linux-ha.org/ReportingProblems
More information about the Linux-HA