> 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 Thanks for the suggestions, but I have looked at all of the replication/availability solutions for postgres and determined this is the way I want to go. Brad Crotchett brad@xxxxxxxxxxxxxx http://www.bradandkim.net -- Linux-cluster mailing list Linux-cluster@xxxxxxxxxx https://www.redhat.com/mailman/listinfo/linux-cluster
