X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B2CAED1B57A; Mon, 24 May 2004 13:29:02 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 04908-05; Mon, 24 May 2004 13:28:42 -0300 (ADT) Received: from COLSWEEPER.cranel.com (newmail.cranel.com [66.192.200.227]) by svr1.postgresql.org (Postfix) with ESMTP id 4B2D7D1B16D; Mon, 24 May 2004 13:28:40 -0300 (ADT) Received: from colmail01.cranel.local (colmail01.cranel.local) by COLSWEEPER.cranel.com (Content Technologies SMTPRS 4.3.12) with ESMTP id ; Mon, 24 May 2004 12:28:09 -0400 Received: from cranel.com (192.168.11.134 [192.168.11.134]) by colmail01.cranel.local with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2657.72) id LRVR96SQ; Mon, 24 May 2004 12:33:21 -0400 Message-ID: <40B222B0.7010204@cranel.com> Date: Mon, 24 May 2004 12:28:32 -0400 From: Greg Spiegelberg Organization: Cranel, Inc. User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.6) Gecko/20040113 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Cc: "pgsql-general@postgresql.org" Subject: Re: Clustering Postgres 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> In-Reply-To: <40B217F2.1080608@did-it.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/248 X-Sequence-Number: 13564 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!