From: Greg Spiegelberg <gspiegelberg@cranel.com>
To: pgsql-admin@postgresql.org
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Subject: Re: Clustering Postgres
Date: Mon, 24 May 2004 12:28:32 -0400
Message-ID: <40B222B0.7010204@cranel.com> (raw)
In-Reply-To: <40B217F2.1080608@did-it.com>
References: <20030310205101.65721.qmail@web41607.mail.yahoo.com>
<20030310205101.65721.qmail@web41607.mail.yahoo.com>
<5.1.0.14.2.20030313080301.01ebea78@mail.earthlink.net>
<20030313121356.J4545@hub.org>
<40ACF95D.4030802@musicrebellion.com>
<1085172198.9127.1549.camel@camel>
<40B1FFDC.9040303@cranel.com>
<40B217F2.1080608@did-it.com>
2 dual PIII-1.4GHz Linux RedHat 3.0 servers each with onboard AIC7xxx
and 2 U160 drives (mirrored), 2 GB of ECC memory, 2 onboard Intel Ether
Pro 100Mbps type NIC's, 1 Qlogic 2310 HBA on a 1GBs SAN using a Candera
510 storage cluster with Xyratex SATA on the backend configured with 1+0
LUN's. It will be using a private network and a small disk on the SAN
as the interconnect.
Once I have it running and I've run the necessary tests for myself
I could run a few tests for anyone else who is interested. Deadline
is June 18th when either I scrap it and try a different solution or
we have to buy in which case I'll need it for our production databases.
Below is the config I intend to use for PostgreSQL 7.4.2.
Greg
PostgreSQL 7.4.2 config & compile
configure \
--prefix=/psfs1/apps/pgsql-7.4.2 \
--enable-thread-safety \
--enable-largefiles \
--enable-odbc \
--enable-multibyte \
--enable-shared \
--enable-syslog \
--with-perl \
--with-CXX \
--with-pam \
--with-maxbackends=128 \
--with-tcl \
--with-readline \
--with-zlib
make -j 2 CPPFLAGS="-O3 -DALLOW_ABSOLUTE_DBPATHS -DLOCK_DEBUG" all
Ericson Smith wrote:
> Do you mean that you are actually testing this product now? If so,
> what's the hardware configuration (nodes, storage server, interconnects)
> that you are using?
>
> Warmest regards, Ericson Smith
> Tracking Specialist/DBA
> +-----------------------+-----------------------------------------+
> | http://www.did-it.com | "3 Years ago I was worth $5M on paper!" |
> | eric@did-it.com | "Sweet! Can I have fries with that?" |
> | 516-255-0500 | - Tom Tomorrow |
> +-----------------------+-----------------------------------------+
>
>
> Greg Spiegelberg wrote:
>
>> Robert,
>>
>> I am currently evaluating PolyServe Matrix Server which is a clustering
>> solution including a clustered file system (mounted read-write
>> everywhere).
>>
>> Anything special anyone wants to know? I'm using PostgreSQL 7.4.2 in
>> a Linux cluster.
>>
>> Greg
>>
>>
>> Robert Treat wrote:
>>
>>> On Thu, 2004-05-20 at 14:30, Kris Kiger wrote:
>>>
>>>> Has anyone heard of clusgres or, better yet, had any experience with
>>>> it? I came across it while searching for active clustering projects.
>>>>
>>>> http://www.linuxlabs.com/clusgres.html
>>>>
>>>> Thanks in advance for the info!
>>>>
>>>
>>>
>>> I have heard of it but I've not heard of any reports on these lists of
>>> how well it works. If you (or anyone else) gives it a spin please try to
>>> post an account to the list and/or if you send me the info it could
>>> probably make its way on to techdocs.
>>> Robert Treat
>>
>>
>>
>>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
--
Greg Spiegelberg
Product Development Manager
Cranel, Incorporated.
Phone: 614.318.4314
Fax: 614.431.8388
Email: gspiegelberg@cranel.com
Technology. Integrity. Focus. V-Solve!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-admin@postgresql.org
Cc: gspiegelberg@cranel.com, pgsql-general@postgresql.org
Subject: Re: Clustering Postgres
In-Reply-To: <40B222B0.7010204@cranel.com>
References: <20030310205101.65721.qmail@web41607.mail.yahoo.com> <5.1.0.14.2.20030313080301.01ebea78@mail.earthlink.net> <20030313121356.J4545@hub.org> <40ACF95D.4030802@musicrebellion.com> <1085172198.9127.1549.camel@camel> <40B1FFDC.9040303@cranel.com> <40B217F2.1080608@did-it.com> <40B222B0.7010204@cranel.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox