pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedDistributed databases
7+ messages / 6 participants
[nested] [flat]
* Distributed databases
@ 2001-08-08 05:17 Robert.Farrugia@go.com.mt
0 siblings, 1 reply; 7+ messages in thread
From: Robert.Farrugia@go.com.mt @ 2001-08-08 05:17 UTC (permalink / raw)
To: pgsql-admin
Does anyone know of any package which allows a database to be distributed
over a number of machines (for e.g. depending on row values, rows from 0 -
100 on machine A, rows 100 - 200 on machine B, etc) ? Preferably this
package should also offer a means to automatically split the query over all
the machines in the domain ?
Thanks
Robert
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Distributed databases
@ 2001-08-08 06:40 Grigoriy G. Vovk <grigoriy.vovk@linustech.com.cy>
parent: Robert.Farrugia@go.com.mt
0 siblings, 1 reply; 7+ messages in thread
From: Grigoriy G. Vovk @ 2001-08-08 06:40 UTC (permalink / raw)
To: Robert.Farrugia@go.com.mt; +Cc: pgsql-admin
Aug 8, 07:17 +0200, Robert.Farrugia@go.com.mt wrote:
> Does anyone know of any package which allows a database to be distributed
> over a number of machines (for e.g. depending on row values, rows from 0 -
> 100 on machine A, rows 100 - 200 on machine B, etc) ? Preferably this
> package should also offer a means to automatically split the query over all
> the machines in the domain ?
Yes, I do, I know a package which does perfect exactly what you want.
It is IBM DB2 Extended Enterprise Edition :))
I don't think you are able to find something similar to DB2 for
PostgreSQL. I'll be happy to be wrong....
my best regards,
----------------
Grigoriy G. Vovk
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Distributed databases
@ 2001-08-08 06:48 Robert.Farrugia@go.com.mt
0 siblings, 0 replies; 7+ messages in thread
From: Robert.Farrugia@go.com.mt @ 2001-08-08 06:48 UTC (permalink / raw)
To: Grigoriy G. Vovk <grigoriy.vovk@linustech.com.cy>; +Cc: pgsql-admin
In fact we are considering various solutions. The ideal one would be to
remain with postgres which reduces the amount of re-implementation of our
current systems, plus remain with a tried and tested system.
Thanks for the tip
Robert
"Grigoriy G. Vovk"
<grigoriy.vovk@linuste To: <Robert.Farrugia@go.com.mt>
ch.com.cy> cc: <pgsql-admin@postgresql.org>
Subject: Re: [ADMIN] Distributed databases
08/08/2001 08:40
Aug 8, 07:17 +0200, Robert.Farrugia@go.com.mt wrote:
> Does anyone know of any package which allows a database to be distributed
> over a number of machines (for e.g. depending on row values, rows from 0
-
> 100 on machine A, rows 100 - 200 on machine B, etc) ? Preferably this
> package should also offer a means to automatically split the query over
all
> the machines in the domain ?
Yes, I do, I know a package which does perfect exactly what you want.
It is IBM DB2 Extended Enterprise Edition :))
I don't think you are able to find something similar to DB2 for
PostgreSQL. I'll be happy to be wrong....
my best regards,
----------------
Grigoriy G. Vovk
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Distributed databases
@ 2001-08-08 14:39 Ross J. Reedstrom <reedstrm@rice.edu>
parent: Grigoriy G. Vovk <grigoriy.vovk@linustech.com.cy>
0 siblings, 0 replies; 7+ messages in thread
From: Ross J. Reedstrom @ 2001-08-08 14:39 UTC (permalink / raw)
To: Grigoriy G. Vovk <grigoriy.vovk@linustech.com.cy>; +Cc: Robert.Farrugia@go.com.mt; pgsql-admin
On Wed, Aug 08, 2001 at 09:40:21AM +0300, Grigoriy G. Vovk wrote:
> Aug 8, 07:17 +0200, Robert.Farrugia@go.com.mt wrote:
>
> > Does anyone know of any package which allows a database to be distributed
> > over a number of machines (for e.g. depending on row values, rows from 0 -
> > 100 on machine A, rows 100 - 200 on machine B, etc) ? Preferably this
> > package should also offer a means to automatically split the query over all
> > the machines in the domain ?
>
> Yes, I do, I know a package which does perfect exactly what you want.
> It is IBM DB2 Extended Enterprise Edition :))
>
> I don't think you are able to find something similar to DB2 for
> PostgreSQL. I'll be happy to be wrong....
Not in the current PostgreSQL source. There was an academic project built
on Postgres95, called Mariposa, that did exactly what you describe. It
was commericalized as Cohera (www.cohera.com) which has retargetted as a
'business content integration solution provider' whatever that means.
They've always targetted the Large Enterprise market, so much so that
I can't find pricing info on their site (if you have to ask ...)
I took a look at porting Mariposa to the current PostgreSQL source about
a year ago, but it was beyond my skills and knowledge at the time. It's
another one of the interesting bits of Postgres history that needs to
be dusted off and looked at again.
Ross
^ permalink raw reply [nested|flat] 7+ messages in thread
* Distributed DataBases
@ 2007-10-14 20:53 Martial Elisée Wendbé KIBA <mkiba01@yahoo.fr>
0 siblings, 1 reply; 7+ messages in thread
From: Martial Elisée Wendbé KIBA @ 2007-10-14 20:53 UTC (permalink / raw)
To: pgsql-admin
Hi all,
I have some questions about postgreSQL, concerning Distributed DataBases.
I know Oracle can do this very Well. With Oracle, i can configure my dataBases to use data stored in another DataSource (Microsoft SQL Server, Access, Access, ...), using Oracle Transparent Gateway.
What i want to know is There is a way to configure PostgreSQL to do the same, or there is contrib/module that i can configure to do the same like Oracle Transparent Gateway.
It is important for me because in my company, there is many DataBases Stored in different SGBDR, and users used to ask about statistical datas that are stored in many SGBDR. It would be of great benefits for me to have all those Datas logicaly stored in one place.
Thanks in advance
Martial Elisée Wendbé KIBA
Ingénieur de Conception en Informatique
876, Avenue du Burkina secteur N°04
01 BP 1132 Ouaga 01
BURKINA FASO
Email: mkiba@delgi.gov.bf
Bureau: (+226) 50 32 62 06
Cel: (+226) 70 15 44 93
_____________________________________________________________________________
Ne gardez plus qu'une seule adresse mail ! Copiez vos mails vers Yahoo! Mail
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Distributed DataBases
@ 2007-10-15 15:42 Jonah H. Harris <jonah.harris@gmail.com>
parent: Martial Elisée Wendbé KIBA <mkiba01@yahoo.fr>
0 siblings, 0 replies; 7+ messages in thread
From: Jonah H. Harris @ 2007-10-15 15:42 UTC (permalink / raw)
To: Martial Elisée Wendbé KIBA <mkiba01@yahoo.fr>; +Cc: pgsql-admin
On 10/14/07, Martial Elisée Wendbé KIBA <mkiba01@yahoo.fr> wrote:
> I have some questions about postgreSQL, concerning Distributed DataBases.
> I know Oracle can do this very Well. With Oracle, i can configure my
> dataBases to use data stored in another DataSource (Microsoft SQL Server,
> Access, Access, ...), using Oracle Transparent Gateway.
> What i want to know is There is a way to configure PostgreSQL to do the
> same, or there is contrib/module that i can configure to do the same like
> Oracle Transparent Gateway.
See the projects:
dblink (Postgres-to-Postgres in contrib)
dblink_odbc (Postgres-to-ODBC on PgFoundry)
dblink_tds (Postgres-to-Sybase/SQL Server on PgFoundry [has a memory leak])
dbi-link (Postgres-to-DBD in Perl)
--
Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324
EnterpriseDB Corporation | fax: 732.331.1301
499 Thornall Street, 2nd Floor | jonah.harris@enterprisedb.com
Edison, NJ 08837 | http://www.enterprisedb.com/
^ permalink raw reply [nested|flat] 7+ messages in thread
* Re: Distributed DataBases
@ 2007-10-16 19:57 Martial Elise KIBA <mkiba@delgi.gov.bf>
0 siblings, 0 replies; 7+ messages in thread
From: Martial Elise KIBA @ 2007-10-16 19:57 UTC (permalink / raw)
To: pgsql-admin
Thanks for your Your Help.
I'll take a look at pg_foundry and test that
Martial E. W. KIBA
Ingénieur de Conception en Informatiques
Option Génie-Logiciel
Tél: (+226) 70 15 44 93
Mail: mkiba@delgi.gov.bf / mkiba01@yahoo.fr
^ permalink raw reply [nested|flat] 7+ messages in thread
end of thread, other threads:[~2007-10-16 19:57 UTC | newest]
Thread overview: 7+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-08-08 05:17 Distributed databases Robert.Farrugia@go.com.mt
2001-08-08 06:40 ` Grigoriy G. Vovk <grigoriy.vovk@linustech.com.cy>
2001-08-08 14:39 ` Ross J. Reedstrom <reedstrm@rice.edu>
2001-08-08 06:48 Re: Distributed databases Robert.Farrugia@go.com.mt
2007-10-14 20:53 Distributed DataBases Martial Elisée Wendbé KIBA <mkiba01@yahoo.fr>
2007-10-15 15:42 ` Re: Distributed DataBases Jonah H. Harris <jonah.harris@gmail.com>
2007-10-16 19:57 Re: Distributed DataBases Martial Elise KIBA <mkiba@delgi.gov.bf>
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