Skip site navigation (1) Skip section navigation (2)

Re: Clustering Postgres

From: Greg Spiegelberg <gspiegelberg(at)cranel(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Cc: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Clustering Postgres
Date: 2004-05-24 16:28:32
Message-ID: 40B222B0.7010204@cranel.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
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(at)did-it(dot)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(at)cranel(dot)com
Technology. Integrity. Focus. V-Solve!


In response to

Responses

pgsql-admin by date

Next:From: LSanchezDate: 2004-05-24 17:02:12
Subject: Re: pg_hba.conf
Previous:From: Bill ChandlerDate: 2004-05-24 16:28:22
Subject: Re: Missing or errooneous pg_hba.conf file

pgsql-general by date

Next:From: Ericson SmithDate: 2004-05-24 17:13:12
Subject: Re: Clustering Postgres
Previous:From: pwDate: 2004-05-24 15:54:12
Subject: unsubscribe

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group