On Tue, Oct 19, 2010 at 12:11:03PM +0800, Linux Cook 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!
First: if your data lives on DRBD (of NFS or any other "shared" thingy), you have to make sure your UID:GID in /etc/passwd (or wherever you store your user information) is identical on all nodes. Or failover will not work. If you have postgres:x:104:104:... on Node A postgres:x:107:107:... on Node B, chances are that all data belongs to uid 104, and uid 107 of the other node will not have permission to access it. To sync up your user ids, or have them centrally managed (which unfortunately becomes an other point of failure, then). Second: get the script used to start/stop/status the resource in shape. How to do so: http://www.linux-ha.org/wiki/LSB_Resource_Agents (and a few other places in the web) -- : Lars Ellenberg : LINBIT | Your Way to High Availability : DRBD/HA support and consulting http://www.linbit.com DRBD® and LINBIT® are registered trademarks of LINBIT, Austria. _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
