[Linux-HA] heartbeat with postgresql
linuxcook at gmail.com
Fri Oct 15 12:41:07 MDT 2010
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,
> > 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