pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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!




view thread (8+ messages)  latest in thread

Message-ID: <40B222B0.7010204@cranel.com>
Permalink:  ../40B222B0.7010204@cranel.com/
Also on:    postgresql.org/message-id/40B222B0.7010204@cranel.com

 · 

reply

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