|
Home > Archive > PostgreSQL Administration > November 2006 > About Distributed Database Systems
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
About Distributed Database Systems
|
|
| Diego Souza 2006-11-07, 7:18 pm |
| Hello,
My name is Diego, I am a Brazilian student, and I would know if there
is some version of PostgreSQL with features to work with distributed
database management.
Where I may to find some document about this functions?
Thanks for attention
Diego
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| Richard Broersma Jr 2006-11-07, 7:18 pm |
| > My name is Diego, I am a Brazilian student, and I would know if there
> is some version of PostgreSQL with features to work with distributed
> database management.
> Where I may to find some document about this functions?
>
> Thanks for attention
I do not believe that the standard package of PostgreSQL support anything that allows you to
distribute your database across various servers. However there are some contrib package that do
this in various ways, depending upon what you want.
If you want create a schema that is distributed across various databases you have the following
choices:
dblink, for postgres to postgres connection
dbi-link, for postgres to anything else.
http://pgfoundry.org/
For replication:
you have slony, etc. al.
http://slony.info/
Regards,
Richard Broersma Jr.
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
|
|
|
|
|