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

help / color / mirror / Atom feed

From: Mark Lewis <mark.lewis@mir3.com>
To: Jim C. Nasby <jnasby@pervasive.com>
Cc: Jeremy Haile <jhaile@fastmail.fm>
Cc: pgsql-performance@postgresql.org
Subject: Re: Postgres and Ingres R3 / SAN
Date: Tue, 07 Mar 2006 11:20:50 -0800
Message-ID: <1141759250.4237.7.camel@archimedes> (raw)
In-Reply-To: <20060307190019.GX82989@pervasive.com>
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>

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.

-- Mark Lewis

view thread (6+ messages)  latest in thread

Message-ID: <1141759250.4237.7.camel@archimedes>
Permalink:  ../1141759250.4237.7.camel@archimedes/
Also on:    postgresql.org/message-id/1141759250.4237.7.camel@archimedes

copy link · copy postgr.es

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: mark.lewis@mir3.com, jnasby@pervasive.com, jhaile@fastmail.fm
  Subject: Re: Postgres and Ingres R3 / SAN
  In-Reply-To: <1141759250.4237.7.camel@archimedes>

* 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