Have you tried to use PGCluster (http://pgcluster.projects.postgresql.org/) or Postgres-R (http://www.postgres-r.org/about/about). You can achieve the same result without having a cluster filesystem. Best regards M.Marinov On Wednesday 15 August 2007 00:17:15 brad@xxxxxxxxxxxxxx wrote: > > I used a generic script resource instead of the supplied Postgres-8. It > > didn't seem to work, but then we needed 2 of them and not 1. > > > > If you're using the init script, try using it as a script resource > > instead. > > > > brad@xxxxxxxxxxxxxx wrote: > >> I am attempting to set up an active/passive failover environment for > >> postgresql-8.2. I created a failover domain with 2 nodes, one of them > >> preferred, added a postgresql-8 resource and an IP address resource. > >> Now > >> when I set up a service I run into problems. The idea is to have both > >> the > >> postgresql-8 resource and the IP address resource within the service so > >> that it will move the floating IP to the other node in the domain and > >> start postgres on it. The IP portion seems to work fine but postgresql > >> always fails. I get these error messages: > >> > >> Aug 14 15:40:47 cdb6 clurgmgrd[4106]: <notice> Starting disabled service > >> 10.10.1.221 > >> Aug 14 15:40:47 cdb6 clurgmgrd: [4106]: <info> Adding IPv4 address > >> 10.10.1.236 to bond0 > >> Aug 14 15:40:48 cdb6 clurgmgrd: [4106]: <info> Starting Service > >> postgres-8:cdb6 > >> Aug 14 15:40:48 cdb6 clurgmgrd: [4106]: <err> Starting Service > >> postgres-8:cdb6 > Failed > >> Aug 14 15:40:48 cdb6 clurgmgrd[4106]: <notice> start on postgres-8:cdb6 > >> returned 1 (generic error) > >> Aug 14 15:40:48 cdb6 clurgmgrd[4106]: <warning> #68: Failed to start > >> 10.10.1.221; return value: 1 > >> Aug 14 15:40:48 cdb6 clurgmgrd[4106]: <notice> Stopping service > >> 10.10.1.221 > >> Aug 14 15:40:48 cdb6 clurgmgrd: [4106]: <info> Stopping Service > >> postgres-8:cdb6 > >> Aug 14 15:40:48 cdb6 clurgmgrd: [4106]: <err> Checking Existence Of File > >> /var/run/cluster/postgres-8/postgres-8:cdb6.pid [postgres-8:cdb6] > > >> Failed > >> - File Doesn't Exist > >> Aug 14 15:40:48 cdb6 clurgmgrd: [4106]: <err> Stopping Service > >> postgres-8:cdb6 > Failed > >> Aug 14 15:40:48 cdb6 clurgmgrd[4106]: <notice> stop on postgres-8:cdb6 > >> returned 1 (generic error) > >> Aug 14 15:40:48 cdb6 clurgmgrd[4106]: <crit> #12: RG 10.10.1.221 failed > >> to > >> stop; intervention required > >> Aug 14 15:40:48 cdb6 clurgmgrd[4106]: <notice> Service 10.10.1.221 is > >> failed > >> Aug 14 15:40:48 cdb6 clurgmgrd[4106]: <crit> #13: Service 10.10.1.221 > >> failed to stop cleanly > >> > >> > >> Here are the relavent portions of cluster.conf: > >> > >> <failoverdomains> > >> <failoverdomain name="cdb6_pgsql" ordered="1" > >> restricted="1"> > >> <failoverdomainnode name="cdb6" > >> priority="1"/> > >> <failoverdomainnode name="cdb5" > >> priority="2"/> > >> </failoverdomain> > >> </failoverdomains> > >> <resources> > >> <clusterfs device="/dev/mapper/gfsvol1" > >> force_unmount="0" fsid="36155" fstype="gfs" > >> mountpoint="/mnt/gfs" name="gfs1" options=""/> > >> <postgres-8 > >> config_file="/var/lib/pgsql/data/postgresql.conf" > >> name="cdb6" postmaster_options="" > >> postmaster_user="postgres" shutdown_wait=""/> > >> <ip address="10.10.1.236" monitor_link="1"/> > >> <script file="/etc/rc.d/init.d/postgresql" > >> name="postgres"/> > >> </resources> > >> <service autostart="0" domain="cdb6_pgsql" > >> name="10.10.1.221" recovery="relocate"> > >> <ip ref="10.10.1.236"/> > >> <postgres-8 ref="cdb6"/> > >> </service> > >> > >> I looked into the init script failing to return zero issue and I don't > >> think that is it. My postgresql startup script doesn't even show that > >> there was an attempt to start it. When setting up a postgresql-8 > >> resource > >> I assume that 'config file' is the config file for postgres or is it the > >> startup script '/etc/rc.d/init.d/postgresql'? Neither works for me. > >> > >> Any tips would be greatly appreciated. > >> > >> Brad Crotchett > > I tried that as well and it still fails. Does rgmanager already know to > use start|stop|restart with the init script? > > Thanks, > > Brad Crotchett > brad@xxxxxxxxxxxxxx > http://www.bradandkim.net > > -- > Linux-cluster mailing list > Linux-cluster@xxxxxxxxxx > https://www.redhat.com/mailman/listinfo/linux-cluster -- Linux-cluster mailing list Linux-cluster@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/linux-cluster
