pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jim C. Nasby <jnasby@pervasive.com>
To: Mark Lewis <mark.lewis@mir3.com>
Cc: Jeremy Haile <jhaile@fastmail.fm>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres and Ingres R3 / SAN
Date: Tue, 7 Mar 2006 13:22:21 -0600
Message-ID: <20060307192221.GA82989@pervasive.com> (raw)
In-Reply-To: <1141759250.4237.7.camel@archimedes>
References: <b2990fb00603060528w634580d3rd3ac3d7f21134e52@mail.gmail.com>
	<f3c0b4080603060656l69bcd619nad204bfcf96c68b4@mail.gmail.com>
	<20060306131355.A1227@ganymede.hub.org>
	<f3c0b4080603061145y61fe3298n101ff51d0fcabcba@mail.gmail.com>
	<1141675112.28202.255960101@webmail.messagingengine.com>
	<20060307190019.GX82989@pervasive.com>
	<1141759250.4237.7.camel@archimedes>

On Tue, Mar 07, 2006 at 11:20:50AM -0800, Mark Lewis wrote:
> On Tue, 2006-03-07 at 13:00 -0600, Jim C. Nasby wrote:
> 
> ...
> 
> > PostgreSQL on a SAN won't buy you what I think you think it will. It's
> > essentially impossible to safely run two PostgreSQL installs off the
> > same data files without destroying your data. What a SAN can buy you is
> > disk-level replication, but I've no experience with that.
> 
> It is possible to run two instances against the same SAN using tools
> such as RedHat's Cluster Suite.  We use that in-house as a cheap
> alternative for Oracle clustering, although we're not using it for our
> PostgreSQL servers yet.  It's not for load balancing, just
> active/passive fault tolerance.

True, but the OP was talking about scaleability, which is not something
you get with this setup.
-- 
Jim C. Nasby, Sr. Engineering Consultant      jnasby@pervasive.com
Pervasive Software      http://pervasive.com    work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf       cell: 512-569-9461



view thread (6+ messages)  latest in thread

Message-ID: <20060307192221.GA82989@pervasive.com>
Permalink:  ../20060307192221.GA82989@pervasive.com/
Also on:    postgresql.org/message-id/20060307192221.GA82989@pervasive.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 using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: jnasby@pervasive.com, mark.lewis@mir3.com, jhaile@fastmail.fm
  Subject: Re: Postgres and Ingres R3 / SAN
  In-Reply-To: <20060307192221.GA82989@pervasive.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