[Linux-cluster] Postgresql service on RHCS

[brad at bradandkim.net]

> 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

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 at bradandkim.net
http://www.bradandkim.net