Received: from localhost (unknown [200.46.204.183]) by developer.postgresql.org (Postfix) with ESMTP id 456192E003A for ; Tue, 13 May 2008 14:12:34 -0300 (ADT) Received: from developer.postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 36593-05 for ; Tue, 13 May 2008 14:12:28 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from sca-es-mail-1.sun.com (sca-es-mail-1.Sun.COM [192.18.43.132]) by developer.postgresql.org (Postfix) with ESMTP id 9DE032E0031 for ; Tue, 13 May 2008 14:12:29 -0300 (ADT) Received: from fe-sfbay-10.sun.com ([192.18.43.129]) by sca-es-mail-1.sun.com (8.13.7+Sun/8.12.9) with ESMTP id m4DHCSp2020774 for ; Tue, 13 May 2008 10:12:28 -0700 (PDT) Received: from conversion-daemon.fe-sfbay-10.sun.com by fe-sfbay-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) id <0K0T00901G5C4O00@fe-sfbay-10.sun.com> (original mail from Robert.Lor@Sun.COM) for pgsql-admin@postgresql.org; Tue, 13 May 2008 10:12:28 -0700 (PDT) Received: from [192.168.1.108] ([76.203.242.247]) by fe-sfbay-10.sun.com (Sun Java System Messaging Server 6.2-8.04 (built Feb 28 2007)) with ESMTPSA id <0K0T00I7IH4KMG90@fe-sfbay-10.sun.com>; Tue, 13 May 2008 10:12:21 -0700 (PDT) Date: Tue, 13 May 2008 12:14:08 -0500 From: Robert Lor Subject: Re: Postgres Cluster on Solaris In-reply-to: <347D0FD56F1C5745B0659D8E27B1BC30021E863E@epi-mail1.optionshouse.net> To: Travis Smith Cc: pgsql-admin@postgresql.org Message-id: <4829CC60.904@sun.com> MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=windows-1252 Content-transfer-encoding: 8BIT References: <347D0FD56F1C5745B0659D8E27B1BC30021E863E@epi-mail1.optionshouse.net> User-Agent: Thunderbird 2.0.0.6 (X11/20071119) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200805/110 X-Sequence-Number: 29194 Travis, Travis Smith wrote: > > Hello All, > > I am interested in running Postgres on Solaris using SunCluster. I am > hoping that someone this list has experience with this configuration. > To be honest I am having a difficult time understanding the concept of > Postgres clusters. I originally began looking at Linux HA, I would > like to run on Suns’ T5220 and I at a loss to how well this setup runs. > There is an ongoing project to integrate Sun Cluster (aka Solaris Cluster) with Postgres warm standby. I recently tested the agent with Postgres running in two Solaris zones on a single node, and the automatic failover worked quite well. I haven't tried the two-node config yet, but it should work. To get more info, check out this project page http://www.opensolaris.org/os/project/ha-postgresql/Active-Subprojects/log-shipping/ -Robert