[Linux-HA] heartbeat with postgresql

[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 changes it user and group ownership instead of just postgres user and
> group.
> 
> 
> Please help!
> 
> Oliver
> _______________________________________________
> 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

Please check which user and group postgres run in both nodes. If they are 
different your have a problem. Solution:

- Reinstall portgres, so that username and group are identical on both nodes.
- make a group in which both user-ID are members and make the directory owned 
by that group. make the directory writebale by the owner.

Greetings,

-- 
Dr. Michael Schwartzkopff
Guardinistr. 63
81375 München

Tel: (0163) 172 50 98
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 198 bytes
Desc: This is a digitally signed message part.
Url : http://lists.linux-ha.org/pipermail/linux-ha/attachments/20101015/0be2dab0/attachment.pgp