Re: [HACKERS] Postgresql on SAN

2004-07-07 Thread Robert Treat
On Wed, 2004-07-07 at 06:39, Yannick Lecaillez wrote: > I have this "clustering on SAN" problem today and Me thinks you've fallen into the trap of proprietary vendors. Your problem isn't that you need "clustering on SAN", your problem is you want some form of high availability solution for your

Re: [HACKERS] Postgresql on SAN

2004-07-07 Thread Bruce Momjian
Yannick Lecaillez wrote: > Thanks a lot for all people which answer. > > I have this "clustering on SAN" problem today and i think it could be > less harder to implement this today than it was for Oracle in 1993 > (since i can find a lot of work in opensource which could be interesting > in this p

Re: [HACKERS] Postgresql on SAN

2004-07-07 Thread Yannick Lecaillez
Thanks a lot for all people which answer. I have this "clustering on SAN" problem today and i think it could be less harder to implement this today than it was for Oracle in 1993 (since i can find a lot of work in opensource which could be interesting in this project : distributed lock, clustered

Re: [HACKERS] Postgresql on SAN

2004-07-06 Thread Greg Stark
Simon Riggs <[EMAIL PROTECTED]> writes: > On Tue, 2004-07-06 at 18:22, Yannick Lecaillez wrote: > > > I would have the pgsql-hackers genius for do that :) . I think its the > > only feature which force company to buy 5$ Oracle licence ... Fwiw, I think you've underestimated the price on those

Re: [HACKERS] Postgresql on SAN

2004-07-06 Thread Simon Riggs
On Tue, 2004-07-06 at 18:22, Yannick Lecaillez wrote: > Le mar 06/07/2004 à 19:07, Alvaro Herrera a écrit : > > On Tue, Jul 06, 2004 at 06:17:16PM +0200, Yannick Lecaillez wrote: > > > > > What need to do (understand, to devel) to allow several > > > postgres instance running from several serve

Re: [HACKERS] Postgresql on SAN

2004-07-06 Thread Yannick Lecaillez
Le mar 06/07/2004 à 19:07, Alvaro Herrera a écrit : > On Tue, Jul 06, 2004 at 06:17:16PM +0200, Yannick Lecaillez wrote: > > > What need to do (understand, to devel) to allow several > > postgres instance running from several server to access to the > > same data (no replication at all) hoste

Re: [HACKERS] Postgresql on SAN

2004-07-06 Thread Peter Eisentraut
Yannick Lecaillez wrote: > What need to do (understand, to devel) to allow several > postgres instance running from several server to access to the > same data (no replication at all) hosted on a SAN ? This is impossible. You can use a SAN if only one node is active at a time, and that is

Re: [HACKERS] Postgresql on SAN

2004-07-06 Thread Alvaro Herrera
On Tue, Jul 06, 2004 at 06:17:16PM +0200, Yannick Lecaillez wrote: > What need to do (understand, to devel) to allow several > postgres instance running from several server to access to the > same data (no replication at all) hosted on a SAN ? Clustered shared memory, cluster-wide spinlock

Re: [HACKERS] Postgresql on SAN

2004-07-06 Thread Richard Huxton
Yannick Lecaillez wrote: Hi ppl, What need to do (understand, to devel) to allow several postgres instance running from several server to access to the same data (no replication at all) hosted on a SAN ? I'm probably wrong but i think this type of dev should be easier to realize than repl

Re: [HACKERS] Postgresql on SAN

2004-07-06 Thread Bruno Wolff III
On Tue, Jul 06, 2004 at 18:17:16 +0200, Yannick Lecaillez <[EMAIL PROTECTED]> wrote: > Hi ppl, > > What need to do (understand, to devel) to allow several > postgres instance running from several server to access to the > same data (no replication at all) hosted on a SAN ? Only once such

[HACKERS] Postgresql on SAN

2004-07-06 Thread Yannick Lecaillez
Hi ppl, What need to do (understand, to devel) to allow several postgres instance running from several server to access to the same data (no replication at all) hosted on a SAN ? I'm probably wrong but i think this type of dev should be easier to realize than replication ? Becaus