Postgres & CODA

From: "Rivera Alejandro" <arivera(at)conectum(dot)net>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Postgres & CODA
Date: 2006-07-04 16:40:59
Message-ID: C2D2EA3B0BDF5746BB2EA541DC77CF4E01911B82@posmex_ml01.corporativo.posadas.com.mx
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I've been reading a lot of documentation trying to find a way to implement a Postgres database on CODA and get it distributed that way. Unfortunately, I found out that CODA apparently doesn't support concurrency over databases, so i came up with an idea of using files, each file containing a single record, so the 2PL locks could be applied to a certain "record-file".
This project will use a global directory with the information about the "fragments" and their location. A fragment would consist of a collection of record-files in a coda volume(directory).
So my question would be: ¿Is there a way to make a single record dump of a given table to a file?, the fact is that I need an horizontal fragmentation, record by record, so ¿how would you do it?
I know this might seem a little nuts, but i would like to get your views on this idea.
Please tell me if I'm just wasting my time hehehehehe :)
Alex Rivera.
PD: please forgive any mispelled words...

Alejandro Rivera Polanco
Base de Datos
1131300 (ext. 3375) - 1131375
arivera(at)conectum(dot)net
Grupo Posadas

Te invitamos a conocer el nuevo Fiesta Inn Reynosa, donde descansa la gente que trabaja.

Browse pgsql-general by date

  From Date Subject
Next Message Sandro Dentella 2006-07-04 18:30:14 How to bypass perm pb on information schema. Request of review
Previous Message Joshua D. Drake 2006-07-04 16:18:25 Re: RAID + PostgreSQL?