[Linux-HA] heartbeat with postgresql
linuxcook at gmail.com
Mon Oct 18 22:11:03 MDT 2010
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:
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?
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"
More information about the Linux-HA