[Linux-cluster] Postgresql service on RHCS
Marian Marinov
mm at yuhu.biz
Wed Aug 15 10:59:22 UTC 2007
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 at bradandkim.net 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 at bradandkim.net 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 at bradandkim.net
> http://www.bradandkim.net
>
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster
More information about the Linux-cluster
mailing list